Data literacy · Digital research and scholarship · Excel · Working with Data

#168 If this then what? Using the IF Function in Excel

The IF function in Excel is a really useful one to be aware of as you can use it to help you to quickly analyse your data. In this example, I use the  IF function to get Excel to tell me if student grades are a pass or a fail. This is a very simple example to get you started, why don’t you have a play with the IF function with your data and see what you can get it to do?

Featured image: “If” by Jonathon Colman licenced under CC BY-NC-ND 2.0

Advertisements

One thought on “#168 If this then what? Using the IF Function in Excel

  1. Great video – the IF function is a great tool to have in your back pocket. The big 3 (SUMIFS – COUNTIFS – AVERAGEIFS) as I like to call them will take you far with your spreadsheets.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s