ExcelBanter - View Single Post

Thank you so much.
S

"Nick Hodge" wrote:

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
HIS

"Sal" wrote in message
...
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(F4200,0,IF(F4<=100,15,IF(F4101or<199,10)))
I think that I need help!!!!!!!
Over to anybody.
Thanks S