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

Don Guillett

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Insert multiple objects at once ? 3
Autonumber field in Excel that behaves the same as Access 0
Making "Change Highlighting" feature darker 1
If then Statement for Excel Columns 2
Excel does not accept text format! 0
Multiple IF statements, macro stops at first True 0
In new Office 2007 EXCEL, can more the 8 IF statements be used? 1

Top