Re: LOOKUP formula
- From: "T. Valko" <biffinpitt@xxxxxxxxxxx>
- Date: Sat, 4 Aug 2007 19:01:08 -0400
I would get rid of that long formula and create a 2 column table for the
amounts and their corresponding charges.
See this screencap:
http://img185.imageshack.us/img185/8459/lookuptz5.jpg
For the last amount of the table (300.01) I use a formula to calculate the
corresponding shipping charge.
Then the lookup formula becomes much more manageable. Also, when
prices/shipping charges go up (and you know they will!) then all you have to
do is update the table rather than messing around and rewriting the formula.
--
Biff
Microsoft Excel MVP
"Snake_Plisken" <SnakePlisken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26372992-6481-4276-8D6E-6D77AC0A00A2@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Formula to Randomly Pair Two Golfers
- Next by Date: Re: IF Statement
- Previous by thread: Re: LOOKUP formula
- Next by thread: Formula to Randomly Pair Two Golfers
- Index(es):
Relevant Pages
|
