Simple formula

R

raff98

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!
 
T

T. Valko

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",""))
 
J

joeu2004

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

Perhaps put the following simple formula into B5:

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

Rick Rothstein \(MVP - VB\)

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

Rick Rothstein \(MVP - VB\)

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
 
Top