A
acw
DMC3
Another way to to do it is to use a VLOOKUP function.
=VLOOKUP(A1,{1,0.94;2,0.87;3,0.67},2,FALSE) is one way.
The same idea using a lookup range is another, especially
if you have a lot of other options. Format B1 to show the
percentage.
Tony
Another way to to do it is to use a VLOOKUP function.
=VLOOKUP(A1,{1,0.94;2,0.87;3,0.67},2,FALSE) is one way.
The same idea using a lookup range is another, especially
if you have a lot of other options. Format B1 to show the
percentage.
Tony