Which formula will return a value for this table?

A

AcctCA755

I created a table in Excel. If the wholesale cost A1, is between a certain
figure, B2-D2, the price will be $39.99 B3-D3. What is the correct formula?

A1
Cost $20.00
B2 C2
D2
Cost Range .01-25.00 25.01-40.00 40.01-50.00

B3 C3
D3
Retail Price 39.99 69.99 89.99


If the cost is less than $25.00, the retail price will be $39.99

If the cost is greater than $25.00, and less than $40.00, the retail price
will be $69.99

If the cost is greater than $40.00, and less than $50.00, the retail price
will be $89.99
 
S

Shane Devenshire

Hi,

You would set up a lookup table in the range, let's say E1:F4:

0 39.99
25 69.99
40 89.99
50

You didn't tell us what happens if the number is >=50 so I left it blank.

The use the formula

=VLOOKUP(A1,E$1:F$4,2)

where the value you are checking is in A1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula/Shipping Chart 4
relective formula 0
Percentage Help 1
Simple If-Then Formula 7
I'am not sure if this is a (=if) problem 4
Deleting lines that use them for formulas 4
Getting a value out of a Matrix 4
Formula for worksheet that's tallying and pricing 5

Top