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

excel word powerpoint courses london - if functions

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - IF Functions

excel word powerpoint courses london - IF Functions

ResolvedVersion Standard

Brian has attended:
Excel Advanced course

IF Functions

How do you incorporate into an IF function a number of conditional 'true' parameters? i.e. =IF(criteria 1 and criteria 2 and criteria 3 are satisfied, True, False)

RE: IF Functions

Hi Brian

Thank you for your question.

As you have pointed out through asking this question, the limitation of the IF function is that it can only evaluate the content of one cell.

If you wish to ask Excel to evaluate more than one cell before deciding which action to take (value_if_true or value_if_false) you can combine the IF function with the AND function to do this.

The AND function returns TRUE if all arguments are true; and FALSE otherwise.

Here is an example of how this might work:

Say you need to Excel to evaluate cell A1, A2 and A3 to see if each cell's value is greater than 100. If each cell's value is greater than 100, then Excel displays yes, if not, Excel displays no.

This is how the formula would look:
=IF(AND(A1>100,A2>100,A3>100,"yes","no")

There is also an OR function which returns TRUE if one of the arguments is true; and FALSE if all arguments are false. That way if you needed Excel to perform an action based on any one of several arguments being true, you could use OR in place of AND in the above formula.

I hope this helps.
Amanda

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.