Which function to use?

  • Thread starter Thread starter Harry Limey
  • Start date Start date
H

Harry Limey

Can someone point me to which function to use to ascertain the following

If a cell contains 1 then I would like the results cell to show 20% of yet
another cell
2 then I would like the results cell to show 10% of
yet another cell
3 then I would like the results cell to show 6.33%
of yet another cell

Much obliged if you can help
 
Gord Dibben said:
In C1............

=LOOKUP(B1,{1,2,3},{0.2,0.1,0.0633})*A1


Gord Dibben MS Excel MVP
Click to expand...

Thanks very much to both of you!

Gord I have used your method as it involved only the most minor of
adjustments and worked perfectly!!

Harry
 
Hello Harry,

You are welcome.

BTW:
=CHOOSE(B1,0.2,0.1,0.0633)*A1
would be 3 times faster than the LOOKUP approach (if speed is an
issue).

Regards,
Bernd
 
Back
Top