Multiple "IF" Statements

[smann2276]

Can someone please tell me what is wrong with my arguments and why the cell will only generate the first result?

=SUM(IF(E28>=0.6-0.7999,D28*0.04,IF(E28+0.8-0.9999,D28*0.06,IF(E28>=1,D28*0.1))))

[JBeaucaire]

Each IF() statement needs an open and close paren:

=SUM(IF(E28>=0.6-0.7999,D28*0.04), IF(E28+0.8-0.9999,D28*0.06), IF(E28>=1,D28*0.1))


I believe there is a problem with the blue formula.

[Dionysos]

You can't do ranges like that. Try something like this:
=IF(E28<0.6,D28,IF(E28<0.8,D28*0.04,IF(E28<1,D28*0.06,D28*0.1)))
I didn't know the calculation if E28 < 0.6 so I just made it equal D28. Also not sure what the SUM function was used for.

[vandan_tanna]

=SUM(IF(E28>=0.6-0.7999,D28*0.04,IF(E28+0.8-0.9999,D28*0.06,IF(E28>=1,D28*0.1))))

blue portion of the formula should be a condition (may be E28 >= 0.8-0.9999?)

[smann2276]

There was a problem with the blue formula....Thanks. Here is the updated formula, the other one was incorrect as it added all of the statements together for the result. I am trying to get different return values based on one particular cell's value.

This one gives me an error:
=IF(E28>=0.6-0.7999,D28*0.04),IF(E28>=0.8-0.9999,D28*0.06),IF(E28>=1,D28*0.1))

This one only provides the results for the first argument:
=IF(E28>=0.6-0.7999,D28*0.04,IF(E28>=0.8-0.9999,D28*0.06,IF(E28>=1,D28*0.1)))

[smann2276]

Thank you!!! Thank you!!! I pulled the ranges and modified your suggestions and it word perfectly. Thank you so very much!! Now I can start living my life again and get some sleep tonight!!

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.