Simple formula
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! |
Simple formula
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! |
Simple formula
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") |
Simple formula
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! |
Simple formula
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 |
All times are GMT +1. The time now is 06:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com