excel-training-course - IF statements

Resolved · Low Priority · Version Standard

Thu 24 Jan 2008, 09:51 Delegate John-paul said...

John-paul has attended:
Excel Intermediate course

IF statements

Is there an easy way to get to grips with using multiple IF statements i.e. is there a working example out there that can show me how to string lots of them together?

Fri 25 Jan 2008, 10:48 Delegate Paul said...

RE: IF statements

=IF(A1>100,"high",IF(A1=100,"exact",IF(A1<100,"low","")))

This illustrates how to use multiple if statements together.

if the result is true, then do one thing, otherwise move onto the next thing and so on.

remember to put a close bracket for every open bracket.

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

excel-training-course - IF statements

IF statements

RE: IF statements

Excel articles

Excel tip:

Calculate age or service