Thread: IF FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vee[_2_] vee[_2_] is offline
external usenet poster
 
Posts: 4
Default 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