If Formula

Resolved · Low Priority · Version 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:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

If Formula

If Formula

RE: If Formula

Attached files...

Excel articles

Excel tip:

Adding date and time