IF FUNCTION
Hi Vasen,
Your formula has a lot of oddities and can be corrected and simplified with
=IF(B26<=0,0%,IF(AND(B260,B26<=4),5%,IF(AND(B264 ,B26<=14),25%,IF(AND(B261
4,B26<=24),50%,75%))))
Firstly, you don't test and AND condition like B26=1<=4 but as
AND(B260,B26<=4)
The, percentage is a value so you don't need it within quotes, just format
the cell as percentage to see 5% rather than 0.05
You don't test for values between 0 and 1 (and others), so I assume this
means that it can on ly be whole numbers, so tests like
IF(B26<=0,0%,IF(AND(B26=1,B26<=4 are better covered by
IF(B26<=0,0%,IF(AND(B260,B26<=4 to catch all instances and to make more
readable
Because it seems to work only on whole numbers you could also use CHOOSE
=IF(B264,75%,CHOOSE(B26+1,0%,5%,25%,50%))
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"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%",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
|