Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 23
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default 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.

    MS Excel 2007 Lecture # 23-excel-if-function-argument.gif

    From the If Function Arguments dialog box displayed, click on the icon with red color pointing upwards behind the Logical_test.

    MS Excel 2007 Lecture # 23-excel-if-function-arguments.gif


    • 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
    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •