Paul Wherly

IF Function (IF Statement) in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010

Here I talk about IF Function (IF Statement) in Microsoft Excel 2010

An If function asks Excel to consider if something is true or false.  If it is true it will return one answer, if it false it will return a different answer.

For example:  Can my company afford to buy 10 new computers? There are 2 possible outcomes – if it is within the budget then the answer is “yes”, if it is outside of the budget then the answer is “no”.

The structure of an IF Function

ExcelF1

The structure of an If statement always contains the same five elements.

  • Starts with =IF(
  • The Logical Test by a comma
  • What to do if the logical test is True followed by a comma
  • What to do if the logical test is False
  • Close brackets

To make this IF function easier to understand the logical test is underlined, the true part is in bold and the false part is in italics.

Operators you can use in a Logical Test

ExcelIF2

Typing in an IF Function

ExcelIF3

1. Click in the cell where you require the answer

2. Type in the =if(

3. Type in your logical test

4. Type a comma

5. Type in what Excel must do if this is true

6. Type a comma

7. Type in what Excel must do if this is false

8. Close the brackets

9. Press enter

If Excel is to display text for the true or false result then you must enclose the text in inverted commas.

You can also put a formula in the IF statement for the True or False result.

[callout]To learn more about IF Function in Excel and to see how we can help your organisation improve their performance with Microsoft Excel 2010 give us a call 020 8203 1774[/callout]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More