| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF Statement
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF Statement
in A1 enter
=.2*A2 and format A1 as percent "John" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF Statement
How about a simple equation?
=A2*0.2 Format A2 to Percentage with 0 decimal places. Another way formatted general. =A1*20 & "%" HTH, Paul "John" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF Statement
=20%*A2
-- David Biddulph "John" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF Statement
THanks Guys,
I was looking for a complicated answer when a simple one will do the same thing... Regards John "John" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple If (Lookup?) Statement | Excel Worksheet Functions | |||
| Multiple If Statement | Excel Worksheet Functions | |||
| Help with a multiple OR statement. | Excel Discussion (Misc queries) | |||
| IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
| IF statement using multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
