Nested Ifs

[Sal]

Hello
I think I need to compile a nested if. I need to set a delivery charge for
anyone who meets a certain criteria such as:
Delivery free for orders over £200
£15 for orders between £1 and £99
£10 for orders between £100 and £199.
I tried
=IF(F4>200,0,IF(F4<=100,15,IF(F4>101or<199,10)))
I think that I need help!!!!!!!
Over to anybody.
Thanks S

 

[Ardus Petus]

=IF(F4<100,15,IF(F4<200,10,0))

HTH

 

[Nick Hodge]

Sal

Try this

=IF(A1="","",IF(A1<100,15,IF(A1<200,10,0)))

The first clause leaves the cell blank if there is no entry in the cell (A1
in the example)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[Aladin Akyurek]

=LOOKUP(F4,{0,1,100,200},{"",15,10,0})

 

[Sal]

Gems as usual - thank you.
S

=IF(F4<100,15,IF(F4<200,10,0))

HTH

 

[Sal]

Thank you so much.
S

Sal

Try this

=IF(A1="","",IF(A1<100,15,IF(A1<200,10,0)))

The first clause leaves the cell blank if there is no entry in the cell (A1
in the example)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]