Thread: MS Excel 2007 Lecture # 23
MS Excel 2007 Lecture # 23
"Excel 2007 IF Function: A Real-Live Example Demonstration"
You can use the IF Function for various purposes. For example, you can use the function to grade student exam scores. If the student has above 85, award an A grade; if the student has below 40, award a fail grade.
The syntax for the IF function is:
=IF (logical_test, value_if_true, value_if_false)
logical_test - a value or expression that is tested to see if it is true or false.
value_if_true - the value that is displayed if logical_test is true.
value_if_false - the value that is displayed if logical_test is false.
To use the Excel 2007 IF function (an example)
- Enter the following data in an Excel worksheet as illustrated.
From the If Function Arguments dialog box displayed, click on the icon with red color pointing upwards behind the Logical_test.
- hen, type in the following formula and click on the red color icon pointing down. B3>=85, "A", IF(B3>=70, "B", IF(B3>=55, "C", IF(B3>=40, "D", "Fail" ) ) )
- Click OK.
- If you want to see the full formula, click on the cell C3 and the formula will be display on the Formula Bar.
Note: Some of the conditional operator you need to know:
< - Less Than
>= - Greater than Or Equal To
<= - Less than Or Equal To
<> - Not Equal To
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)