Results 1 to 4 of 4

Thread: Multiple MUltiplication String

  1. #1

    Multiple MUltiplication String

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am very bad at excel and I hope you can help me with my equation.
    I am sure it is rather simple, however not for myself as I can not figure it out.

    my data as follows, for example:

    cell O15 is my quantity
    cell T15 is price A
    cell U15 is price B
    cell V15 is price C

    when O15 quantity is <6, it is Price A (T15), when the quantity >5 but <11 it is Price B U15, and of course when the quantity is >10 the Price is C V15,
    I have come up with the string: =IF((O15)<6,O15*t15, 0) and this is my start, but how do i connect the remaining two variables in the same string?
    Your help will be greatly appreciated.

  2. #2


    or reduce it to


  3. #3
    Just for fun, another solution


  4. #4

    Red face Hey Bob,

    Thank you very much!
    That string worked just perfect.

    Thanks agaiin


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts