DO NOW
EQ: WHAT ARE IF FUNCTOINS IN EXCEL?
LT: I WILL TRANSLATE IF FUNCTIONS REQUIRING MULTIPLE DATA VALIDATION
ASSESSMENT: CONVERT NUMBER GRADES TO LETTER GRADES USING "IF" FUNCTIONS
CORNELL NOTES
|
NOTES‘IF’ function can be complex in nature. When you are asking for more than one result based on a specific criteria. The result of the IF function formula will depend on multiple variable unlike a PASS or FAIL.
In the case of converting numbers to letter grades you have a range of grades that can be called either an A,B,C,D, F. IF SCORE IS LETTER GRADE Greater than 89 A From 80 to 89 B From 70 to 79 C From 60 to 65 D Less than 65 F In this special case you have to create an extended that sounds like this. If the score is greater than an 89 then the letter grade value is an "A" BUT If the score is greater than or equal to an 80 then the letter grade value is an "B" But if the score is ....? The syntax for IF function is described above includes:
To test whether conditions are true or false, we use logical operators. Examples of logical operators include: < less than > greater than = equal to <= less than or equal to >= greater than or equal to <> not equal to |
Activity 1: Create the If Function to convert the number grade to one of the letter grades shown below
Excample: To get an A the if function would be ---->
=IF(Numerical Grade >=95, "A")
=IF(Numerical Grade >=95, "A")
ACTIVITY 2 + 3: LOGICAL FUNCTIONS EXCEL
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
logical-functions.xlsx | |
File Size: | 39 kb |
File Type: | xlsx |
YOUR SPREAD SHEET FOR ACTIVITY 2 SHOULD LOOK LIKE THIS. YOU CAN USE DIFFERENT COLORS FOR YOUR COLUMN HEADERS. THE ANSWERS ARE SHOWN BELOW. PLEASE BE SURE TO USE THE PROPER FORMULAS TO YIELD THE ANSWERS SHOWN.