Marriage of two formulas

  • Thread starter emerald_dragonfly
  • Start date
E

emerald_dragonfly

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...
 
B

bj

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.
 
Top