Marriage of two formulas

G

Guest

How do I add a maximum pricing level to the following formula?

=VLOOKUP(A1,{0,35;665,5.25;1000,4.75;2500,3;5000,2.5;10000,1.95},2)

I need the maximum to be 465.
 
D

Dave Peterson

=max(10,yourformulahere)





emerald_dragonfly said:
How do I add a maximum pricing level to the following formula?

=VLOOKUP(A1,{0,35;665,5.25;1000,4.75;2500,3;5000,2.5;10000,1.95},2)

I need the maximum to be 465.
Click to expand...
 
G

Guest

try something like
=min(465,VLOOKUP(A1,{0,35;665,5.25;1000,4.75;2500,3;5000,2.5;10000,1.95},2)
Depending on what parameter is the pricing level.
 

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

EXCEL - IF(IFERROR(VLOOKUP question 0
Finding Row and Column Numbers 4
VLOOKUP with cell address as part of the argument 1
Copy a formula using Vlookup 2
VLOOKUP in 2003 1
Correct format for linking a workbook and a formula 2
Partial Eclipse 2
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1

Top