Thread
:
Marriage of two formulas
View Single Post
#
2
Dave Peterson
Posts: n/a
=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
Reply With Quote