S
Snake_Plisken
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,85.01,100.01,150.01,200.01,300.01;3,5,6,7,8,9,10,11,13,14,IF(E39+E40>300,(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
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,85.01,100.01,150.01,200.01,300.01;3,5,6,7,8,9,10,11,13,14,IF(E39+E40>300,(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