Excel Formula

[Guest]

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%.

 

[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

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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%.

 

[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