| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function and VLookup Alternatives | Excel Worksheet Functions | |||
| Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
| Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| Use of more then 7 nested if statement | Excel Worksheet Functions | |||
Linear Mode
