G Guest Oct 5, 2004 #1 My boss is wanting to use the Excel 'wizard' and make an if-than statement....
D Don Guillett Oct 5, 2004 #2 try if(a1="hi",2,"no") -- Don Guillett SalesAid Software (e-mail address removed) yorkielover02 said: My boss is wanting to use the Excel 'wizard' and make an if-than Click to expand... statement....
try if(a1="hi",2,"no") -- Don Guillett SalesAid Software (e-mail address removed) yorkielover02 said: My boss is wanting to use the Excel 'wizard' and make an if-than Click to expand... statement....
D Dave R. Oct 5, 2004 #3 Go to insert>function> and choose "if" then read the labels and enter your stuff. Or you can do it right from the worksheet, enter for example =IF(1+1=2,"correct","incorrect") yorkielover02 said: My boss is wanting to use the Excel 'wizard' and make an if-than Click to expand... statement....
Go to insert>function> and choose "if" then read the labels and enter your stuff. Or you can do it right from the worksheet, enter for example =IF(1+1=2,"correct","incorrect") yorkielover02 said: My boss is wanting to use the Excel 'wizard' and make an if-than Click to expand... statement....
G Gord Dibben Oct 5, 2004 #4 A bit short on detail. Example only.... =IF(A1="boss","dimwit","yorkiefired") To use the Wizard, click on the fx and select "logical" from the categories. Select IF and OK. Enter the options in the appropriate boxes. Use the collapse buttons to go to cell references. Text must have the quotemarks around it. Numbers can be entered without quotes. If you need more, post back with specifics. Gord Dibben Excel MVP
A bit short on detail. Example only.... =IF(A1="boss","dimwit","yorkiefired") To use the Wizard, click on the fx and select "logical" from the categories. Select IF and OK. Enter the options in the appropriate boxes. Use the collapse buttons to go to cell references. Text must have the quotemarks around it. Numbers can be entered without quotes. If you need more, post back with specifics. Gord Dibben Excel MVP
