IF

Resolved · Low Priority · Version 2003

Thu 25 Jun 2009, 14:10 Delegate Tom said...

Tom has attended:
Excel Advanced course

IF

How do you have multiple criteria's?

Mon 29 Jun 2009, 13:19 Trainer Amanda said...

RE: IF

Hello Tom

Thank you for your question and welcome to the forum.

When using the IF function you can nest the AND or OR function within it so that you can test or evaluate more than one cell.

When ALL criteria need to be met in order for the value_if_true part of the function to be carried out, use AND:
=IF(AND(....),value_if_true,value_if_false).

When ONE of the criteria needs to be met in order for the value_if_true part of the function to be carried out, use OR:
=IF(OR(....),value_if_true,value_if_false)

I hope this helps.

Kind regards
Amanda

Mon 6 Jul 2009: Automatically marked as resolved.

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips

IF

IF

RE: IF

Excel articles

Excel tip:

Adding up time greater than 24 hours