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.
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.
=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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks