IF FUNCTION
hi
Please could someone advise what is wrong with this formula:
=IF(B26<=0,"0%",IF(B26=1<=4,"5%",IF(B26<=4,"5%",I F(B26=5<=14,"25%",IF(B26<=14,"25%",IF(B26=15<=24 ,"50%",IF(B26<=24,"50%",IF(B26=25,"75%"))))))) )
The problem is if B26<0 it works...but if B26=0 it evaluates to 5% not
to 0% as it should according to the formula.
Thanks
Vasen
|