View Single Post
  #1   Report Post  
emerald_dragonfly
 
Posts: n/a
Default 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.