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.

Advertisements

About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at www.sequentiasolutions.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