IF Function not working

S

sonicj

The first and second IF functions are working, but not the third:
=IF(B1<B2,C1*.005,IF(B1>=B2,C1*.01,IF(B1>=B3,C1*.012)))
I assume it has something to do with the >= but I don't know another way.
Thank you.
 
G

Guest

sonicj said:
The first and second IF functions are working, but not the third:
=IF(B1<B2,C1*.005,IF(B1>=B2,C1*.01,IF(B1>=B3,C1*.012)))
I assume it has something to do with the >= but I don't know another way.
Thank you.
Click to expand...

As I understand the logic of your expression it can never get to the
third branch (which seems to be what you're experiencing).

1) if B1 < B2, THEN Case1

2) If B1 >= B2 THEN Case2

3) Can't ever get to Case3. ALL cases will be trapped by 1 or 2.

If you understand K Maps for logic design, apply one to your equations
and it will leap right off the paper at you.


Perhaps you intended:

= IF(B1<B2,C1*.005,IF(B1>=B3,C1*.012,C1*.01))

Good luck...

Bill
 
Top