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
|