Multiple IF Statement

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi
I am trying to make a cell produce a value baed on the curent value entered
in a cell..

i.e. Cell A2 can have 4 possible numbers 1,2,3,4
Cell A1 should be either 20%, 40%, 60%, 80% depending on the
number selected 1 = 20% etc

How would I use a formula in cell A1 to produce this requirement. A
multiple IF Statement possibly?


Regards

John
 
How about a simple equation?

=A2*0.2
Format A2 to Percentage with 0 decimal places.

Another way formatted general.
=A1*20 & "%"

HTH,
Paul
 
THanks Guys,
I was looking for a complicated answer when a simple one will do the same
thing...
Regards

John
 
Back
Top