Simple formula

  • Thread starter Thread starter raff98
  • Start date Start date
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!
 
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",""))
 
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")
 
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
 
Back
Top