Excel Formula

I

IndyAspen

In Excel 2000, can I create a formula that will auto populate a cell
depending on a specific argument. Such as, If cell A3 is "yes", then B3
should auto populate 25%; if cell A3 is "no", then B3 should auto populate 0%.
 
N

Niek Otten

In cell B3:

=IF(A3="yes",25%,0%)

But what if cell A3 is something else?

=IF(A3="yes",25%,IF(A3="no",0%,"Don't know"))

Format B3 as Percentage

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
F

Frank Kabel

Hi
=IF(A3="yes",25%,IF(A3="no",0%,""))

--
Regards
Frank Kabel
Frankfurt, Germany

IndyAspen said:
In Excel 2000, can I create a formula that will auto populate a cell
depending on a specific argument. Such as, If cell A3 is "yes", then B3
should auto populate 25%; if cell A3 is "no", then B3 should auto
Click to expand...
populate 0%.
 
B

Bill Kuunders

Enter in B3 =if(A3="yes","25%",if(A3="no","0%",""))
The last part will ensure the cell stays blank if not "yes" or "no"

Regards
Bill K
 
Top