I want a formula where if cell B3 = "yes", than B5 = "Tested", if "No", B5 =
"Not Tested"

I tried the simple help, all I ended up was with the formula showing in cell
B5 (I tried the ctl+)

Thanks!

I ended up was with the formula showing in cell B5

Sounds like cell B5 is formatted as TEXT. Change the format to GENERAL then
retype the formula.

=IF(B3="Yes","Tested",IF(B3="No","Not Tested",""))

--
Biff
Microsoft Excel MVP


"raff98" wrote in message
...
I want a formula where if cell B3 = "yes", than B5 = "Tested", if "No", B5
=
"Not Tested"

I tried the simple help, all I ended up was with the formula showing in
cell
B5 (I tried the ctl+)

Thanks!

On Dec 16, 9:24 am, raff98 wrote:
I want a formula where if cell B3 = "yes", than B5 = "Tested", if "No", B5 =
"Not Tested"

Perhaps put the following simple formula into B5:

=if(B3="yes", "Tested", "Not Tested")

Is Sunday... things are slow... I'm bored... so to be different...

"raff98" wrote in message
...
I want a formula where if cell B3 = "yes", than B5 = "Tested", if "No", B5
=
"Not Tested"

I tried the simple help, all I ended up was with the formula showing in
cell
B5 (I tried the ctl+)

Thanks!

I **hate** the Ctrl+Enter short-cut that physically sends the message in
Windows Mail (and Outlook Express)! Let's try it again.

It's Sunday... things are slow... I'm bored... so to be different...

=RIGHT("Not Tested",6*(B5="Yes")+10*(B5="No"))

Rick