Multiple IF functions

[sonicj]

I need one function to always be true and then two IF functions, but can't
seem to get them all to work together.
=C1*.005,IF(B1>=A1,C1*.01,"NO"),IF(B1>=D1,C1*.012,"NO")
Thank you.

 

[sonicj]

In addition, I've tried this,

=IF(C1>1,C1*.005,IF(B1>=A1,C1*.01,IF(B1>=D1,C1*.012,"NO")))

but keep getting the result from the first IF function no matter what I
enter for B1. Thank you.

 

[Biff]

Hi!

but keep getting the result from the first IF function no
matter what I enter for B1.

=IF(C1>1

If that condition is true the formula stops at this point:

=IF(C1>1,C1*.005)

It doesn't matter what you enter in B1 because the formula
never gets that far if C1>1.

There's nothing wrong with the formula' syntax. May be
that the logic is just not correct for the result you're
after.

Biff

 

[Michael]

Hi
Try this:
=IF(B1>=A1,C1*0.11,IF(B1>=D1,C1*0.012,IF(C1>1,C1*0.005,"NO")))

HTH
Michael