There is no indication on what action should be taken if B1<B3, the False
condition

http://HelpExcel.com

"sonicj" wrote:

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*.0 12)))
I assume it has something to do with the = but I don't know another way.
Thank you.