Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP formula
I have created an Excel Order form. After the Subtotal and Tax have been
calculated, I want the form to automatically put in the handling charges. Formula works beautifully until I need it to return correct result for orders above $300. I would like every order that is over $300 to have handling charges equal to 7% of the order. My formula is: =LOOKUP(E39+E40,{0,10.01,25.01,40.01,55.01,70.01,8 5.01,100.01,150.01,200.01,300.01;3,5,6,7,8,9,10,11 ,13,14,IF(E39+E40300,(E39+E40)*7%})) Can I place an IF statement within a LOOKUP? After the error, Excel highlights the *7%. Please help and Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup formula | Excel Worksheet Functions | |||
Lookup formula help | Excel Worksheet Functions | |||
Lookup formula? | Excel Discussion (Misc queries) | |||
Lookup formula? | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |