Is anyone familiar with an if than statement for Excel? Using Wiza

Y

yorkielover02

My boss is wanting to use the Excel 'wizard' and make an if-than statement....
 
D

Dave R.

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

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
 
Top