Help with excel IF formula

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am trying (hard) to work out the following but everytime I put a formula in I just can't seem to get it right so am looking for some help.

IF C2 >=£0.01 and <=£0.99 then "£0.00"
IF C2 >=£1.00 and <=£4.99 then "£0.15"
IF C2 >=£5.00 and <=£14.99 then "£0.25"
IF C2 >=£15.00 and <=£29.99 then "£0.50"
IF C2>=£30.00 and <=£99.99 then "£1.00"
IF C2>=£100 then £1.30

Thanks in advance.

Kirsty

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
=IF(AND(C2>=0.01,C2<=0.99),0,IF(AND(C2>=1,C2<=4.99),0.15,IF(AND(C2>=5,C2<=14.99),0.25,IF(AND(C2>=15,C2<=29.99),0.5,IF(AND(C2>=30,C2<=99.99),1,IF(C1>100,1.3,0))))))

It is a long formula. study this formula with "and"s, brackets etc you can crate your own formula next time.

there are six ifs. in versions before excel 2007 there can be only maximum of seven ifs
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
do a search on google for nested if statements in excel