ExcelBanter - Marriage of two formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Marriage of two formulas (https://www.excelbanter.com/excel-discussion-misc-queries/33673-marriage-two-formulas.html)

emerald_dragonfly

Marriage of two formulas

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.

Dave Peterson

=max(10,yourformulahere)

emerald_dragonfly wrote:

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.

--

Dave Peterson

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.

"emerald_dragonfly" wrote:

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.

All times are GMT +1. The time now is 04:49 PM.