excel word powerpoint courses london - if functions

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

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

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

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.1 secs.