Nested Ifs
 

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

Nested Ifs
 

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

HTH
--
AP

"Sal" a écrit dans le message de
...
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

Nested Ifs
 

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

Nested Ifs
 

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

Sal wrote:
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

Nested Ifs
 

Gems as usual - thank you.
S

"Ardus Petus" wrote:

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

HTH
--
AP

"Sal" a écrit dans le message de
...
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

Nested Ifs
 

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