Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If Formula

If Formula

ResolvedVersion 2007

Fri 20 Feb 2009, 15:29 Delegate Bill said...

Bill has attended:
Excel Intermediate course

If Formula

Can 'If Formula' handle text rather than numerical values?
e.g.if red then A, if blue then B?

Sat 21 Feb 2009, 20:45 Trainer Cress said...

RE: If Formula

Hello Bill
Thank you for your question

Absolutely, please find attached a spreadsheet with example IF statements based on your colour example.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Attached files...

IF Samples.xls

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

If Formula

If Formula

RE: If Formula

Attached files...

Excel articles

Excel tip:

Highlighting only Text cells