fix a multiple IF statement

[Breezey]

hi guys can you look at this please:

=IF(G9="N","Free",IF(I9<"5.00","£2.50",IF(I9>"15","£2.50",IF(I9>"25","Free"))))

basicly i need to work out a delivery system where by if G9 = N then delivery is free, but also i need to work out that if G9 = Y and I9 is between £5 and £15 delivery is £2.50 but also if its greater than £25 its Free and less than "£5" an error is displayed as the order is too small.


cheers

[dlloyd]

hi guys can you look at this please:

=IF(G9="N","Free",IF(I9<"5.00","£2.50",IF(I9>"15","£2.50",IF(I9>"25","Free"))))

basicly i need to work out a delivery system where by if G9 = N then delivery is free, but also i need to work out that if G9 = Y and I9 is between £5 and £15 delivery is £2.50 but also if its greater than £25 its Free and less than "£5" an error is displayed as the order is too small.


cheers

What if it's between £15 and £25?

Try

=IF(G9="N","Free",IF(I9<5.00,"Too small",IF(I9<15,"£2.50",IF(I9<25,"It's between 15 and 25","Free"))))

[Breezey]

everything appears to work except that last part i made an orsder that was £142 just to see and it still says £2.50 perhaps we need another if in there to say if G9=Y with some kind of AND if thats possible in excel

edit: also still displays £2.50 when the order is less than £5

Double edit: got this =IF(G9="N","Free",IF(I9<5,"Order Value to Low",IF(I9>15,"£2. 50",IF(I9>25,"Free")))) stops orders less than £5

[daddylonglegs]

You don't say what the charge is between £15 and £25, I'm assuming that's £2.50 too

=IF(G9="","",IF(OR(G9="N",I9>=25),"Free",IF(I9<5,"Too small",2.5)))

format as currency

[Breezey]

hmm im not sure this is all he data i have been given, £25 or over is Free, Between £5 - £15 is £2.50 which i take it as a typo, less than £5 = Error

Edit: =IF(G9="","",IF(OR(G9="N",I9>=25),"Free",IF(I9<5," Too small",2.5))) this appears to work but i now need to change the order as they could potentially order somthing with free delivery and with somthing that doesnt have free delivery