View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default formula for range values question

Another way:

the following in A1:F8

variable 1 2 3 4 5
min 0 5 8 10 20
max 10 15 20 30 60

output 15 13 30 20 10
params 1 2 3 4 5

result 10 13 20 20 20

Formula in B8:
=IF(B5<=INDEX($B$1:$F$3;2;B6);INDEX($B$1:$F$3;2;B6 );IF(B5=INDEX($B$1:$F$3;3;B6);INDEX($B$1:$F$3;3;B 6);B5))
Copied to the right to F8.

Hans