Writing an IF Function in Excel to Determine As, Bs, Cs, Ds, and Fs

This post will teach you how to write an IF Function in Excel to determine student grades. Lets say that we have a class list of names and scores ranging from zero to 100. If you would like to have Excel determine the grade next in the column next to the student’s scores, this is one way.

The IF Function has 3 arguments. First, the logical test. An example would be if you wanted to check whether something was true or false like is C2>=90. The second and third arguments are what you would like to have if it is true and if it is false. When you have multiple criteria such as As, Bs, Cs, Ds, and Fs: then you can nest the IF function within the false argument.

if Function Excel

IF Function

So this formula has a total of 4 IFs. That is because there is 5 possible choices of outcomes. A-B-C-D-F. So on the last IF statement, if comes down to if the grade is greater than or equal to 60. If that is true then result is “D” otherwise it is false and the result is an “F”.

If you want to download this file click IF Function Example for grades.xlsx.

About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at 5dollardinners.com.
This entry was posted in Excel and tagged . Bookmark the permalink.

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