Hi Vasen!

It's working OK for me, although I can't see why you're not using
VLOOKUP. Also, you haven't covered empty cell or text inputs to B26


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"vee" wrote in message
om...
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%",I
F(B26<=14,"25%",IF(B26=15<=24,"50%",IF(B26<=24,"5 0%",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