{"id":93,"date":"2024-05-01T09:33:40","date_gmt":"2024-05-01T09:33:40","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-6-if-function\/"},"modified":"2024-09-18T00:52:31","modified_gmt":"2024-09-18T00:52:31","slug":"chapter-6-if-function","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-6-if-function\/","title":{"raw":"Chapter 6: IF Function","rendered":"Chapter 6: IF Function"},"content":{"raw":"
\r\n
\r\n

Learning Objectives<\/p>\r\n\r\n<\/header>\r\n

\r\n
    \r\n \t
  1. Use the IF function.<\/li>\r\n \t
  2. Rename a worksheet.<\/li>\r\n \t
  3. Insert a new worksheet.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<\/div>\r\n

    This is one of the most popular functions in Excel where you can make logical comparisons between a value and what you expect. In other words, you can have two results from the [pb_glossary id=\"190\"]IF[\/pb_glossary] function. The first result is if your comparison is True, and the second is if your comparison is False. It should be either the first or second result depending on True or False.<\/p>\r\n

    Let\u2019s learn the IF function.<\/p>\r\n

    The Figure below shows an example using the IF function.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.1 Type the contents and the formula using the IF function.[\/caption]\r\n

    Type the contents in their respective cells. Use the default font and font size. You may bold and centre the content in each cell as shown in the Figure. Adjust any column width if necessary.<\/p>\r\n

    In cell B2, type the formula using the IF function, =IF(A2=5,\u201cTrue\u201d,\u201cFalse\u201d). Press Enter and you get the result. Excel returns True as the result in cell B2 as the logical comparison A2=5 is correct.<\/p>\r\n

    The logical comparison is whether A2=5 and since cell A2 contains 5, the logical comparison is True. Excel therefore returns True in cell B2, otherwise False if cell A2 contains other value other than 5.<\/p>\r\n

    Now, copy the formula in cell B2 and paste it to the remaining cells in the same column until cell B8 using the Fill Handle.<\/p>\r\n

    The Figure below shows all cells in column B have been filled with the formulas using the IF function.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.2 Copy the formula from cell B2 to the remaining cells in the same column.[\/caption]\r\n

    You can observe from the above Figure that cells B5, B6, and B8 have True results since the values are equal to 5 respectively.<\/p>\r\n

    You can save this workbook using any file name or Chapter6.xlsx as shown in the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.3 Save the workbook as Chapter6.xlsx.[\/caption]\r\n

    Let\u2019s learn the second example of the IF function.<\/p>\r\n

    You are going to create another worksheet for the second example of the IF function in the same workbook.<\/p>\r\n

    Before you proceed, rename the current worksheet name from Sheet1 to True or False. Double-click the worksheet tab and straight away type the new worksheet name.<\/p>\r\n

    See the Figures below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.4 Double-click the worksheet tab to select it.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.5 Type the new worksheet name on the worksheet tab[\/caption]\r\n

    Now, insert a new worksheet. Click the plus (+) button on the right of the worksheet tab and a new worksheet is inserted immediately and you can type the new worksheet name. See the Figures below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.6 Click the plus button after the worksheet tab to insert a new worksheet.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.7 The new worksheet with the default name, Sheet1[\/caption]\r\n

    Rename the new worksheet as Test Result. See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.8 Type Test Result as the new worksheet name[\/caption]\r\n

    The second example of the IF function is illustrated in the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.9 Type the contents and the formula using the IF function.[\/caption]\r\n

    Type the contents in their respective cells. Use the default font and font size. You may bold and centre the content in each cell as shown in the Figure. Adjust any column width if necessary.<\/p>\r\n

    In cell C2, type the formula using the IF function, =IF(B2>50,\u201cPass\u201d,\u201cFail\u201d). Press Enter and you get the result as Fail as displayed in cell C2. The formula instructs Excel to determine whether the logical comparison of the value in cell B2 is greater than 50 (B2>50), but since it is 26 which is less than 50, Excel returns Fail in cell C2. Unlike the first example, False is replaced by Fail as it is written in the formula. In other words, Excel returns a False statement according to the IF formula.<\/p>\r\n

    The formula can be read, if a value in cell B2 is greater than 50, then Pass will be displayed (True), or if a value in cell B2 is less than 50, then Fail will be displayed (False).<\/p>\r\n

    Now, copy the formula in cell C2 and paste it to the remaining cells in the same column until cell C10 using the Fill Handle.<\/p>\r\n

    The Figure below shows all cells in column C have been filled with the formulas using the IF function.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 6.10 Copy the formula from cell C2 to the remaining cells in the same column[\/caption]\r\n

    You can observe from the above Figure that cells C3, C5, C8, and C10 have Pass results since the scores are greater than 50 (>50) respectively. Cells C4, C6, C7, and C7 show the Fail results as the scores are less than 50.<\/p>\r\n

    In using the IF function, you can use the following logical operators to make the comparison in the logical test.<\/p>\r\n

    See below.<\/p>\r\n\r\n

    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    \r\n\r\nOperator<\/strong>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n
    		\r\n
    \r\n\r\nDescription<\/strong>\r\n\r\n<\/div><\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n=\r\n\r\n<\/div><\/td>\r\n
    		Equal to<\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n<>\r\n\r\n<\/div><\/td>\r\n
    		Not equal to<\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n<\r\n\r\n<\/div><\/td>\r\n
    		Less than<\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n>\r\n\r\n<\/div><\/td>\r\n
    		Greater than<\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n<=\r\n\r\n<\/div><\/td>\r\n
    		Less than or equal to<\/td>\r\n<\/tr>\r\n
    \r\n
    \r\n\r\n>=\r\n\r\n<\/div><\/td>\r\n
    		Greater than or equal to<\/td>\r\n<\/tr>\r\n
    <\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n

    The IF function lets you make informed decisions based on the data on the worksheet.<\/p>\r\n

    That\u2019s all for this Chapter.<\/p>\r\n

    You're awesome!<\/p>\r\n\r\n<\/div>","rendered":"

    \n
    \n
    \n

    Learning Objectives<\/p>\n<\/header>\n

    \n
      \n
    1. Use the IF function.<\/li>\n
    2. Rename a worksheet.<\/li>\n
    3. Insert a new worksheet.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

      This is one of the most popular functions in Excel where you can make logical comparisons between a value and what you expect. In other words, you can have two results from the IF<\/a> function. The first result is if your comparison is True, and the second is if your comparison is False. It should be either the first or second result depending on True or False.<\/p>\n

      Let\u2019s learn the IF function.<\/p>\n

      The Figure below shows an example using the IF function.<\/p>\n

      \"image\"
      Figure 6.1 Type the contents and the formula using the IF function.<\/figcaption><\/figure>\n

      Type the contents in their respective cells. Use the default font and font size. You may bold and centre the content in each cell as shown in the Figure. Adjust any column width if necessary.<\/p>\n

      In cell B2, type the formula using the IF function, =IF(A2=5,\u201cTrue\u201d,\u201cFalse\u201d). Press Enter and you get the result. Excel returns True as the result in cell B2 as the logical comparison A2=5 is correct.<\/p>\n

      The logical comparison is whether A2=5 and since cell A2 contains 5, the logical comparison is True. Excel therefore returns True in cell B2, otherwise False if cell A2 contains other value other than 5.<\/p>\n

      Now, copy the formula in cell B2 and paste it to the remaining cells in the same column until cell B8 using the Fill Handle.<\/p>\n

      The Figure below shows all cells in column B have been filled with the formulas using the IF function.<\/p>\n

      \"image\"
      Figure 6.2 Copy the formula from cell B2 to the remaining cells in the same column.<\/figcaption><\/figure>\n

      You can observe from the above Figure that cells B5, B6, and B8 have True results since the values are equal to 5 respectively.<\/p>\n

      You can save this workbook using any file name or Chapter6.xlsx as shown in the Figure below.<\/p>\n

      \"image\"
      Figure 6.3 Save the workbook as Chapter6.xlsx.<\/figcaption><\/figure>\n

      Let\u2019s learn the second example of the IF function.<\/p>\n

      You are going to create another worksheet for the second example of the IF function in the same workbook.<\/p>\n

      Before you proceed, rename the current worksheet name from Sheet1 to True or False. Double-click the worksheet tab and straight away type the new worksheet name.<\/p>\n

      See the Figures below.<\/p>\n

      \"image\"
      Figure 6.4 Double-click the worksheet tab to select it.<\/figcaption><\/figure>\n
      \"image\"
      Figure 6.5 Type the new worksheet name on the worksheet tab<\/figcaption><\/figure>\n

      Now, insert a new worksheet. Click the plus (+) button on the right of the worksheet tab and a new worksheet is inserted immediately and you can type the new worksheet name. See the Figures below.<\/p>\n

      \"image\"
      Figure 6.6 Click the plus button after the worksheet tab to insert a new worksheet.<\/figcaption><\/figure>\n
      \"image\"
      Figure 6.7 The new worksheet with the default name, Sheet1<\/figcaption><\/figure>\n

      Rename the new worksheet as Test Result. See the Figure below.<\/p>\n

      \"image\"
      Figure 6.8 Type Test Result as the new worksheet name<\/figcaption><\/figure>\n

      The second example of the IF function is illustrated in the Figure below.<\/p>\n

      \"image\"
      Figure 6.9 Type the contents and the formula using the IF function.<\/figcaption><\/figure>\n

      Type the contents in their respective cells. Use the default font and font size. You may bold and centre the content in each cell as shown in the Figure. Adjust any column width if necessary.<\/p>\n

      In cell C2, type the formula using the IF function, =IF(B2>50,\u201cPass\u201d,\u201cFail\u201d). Press Enter and you get the result as Fail as displayed in cell C2. The formula instructs Excel to determine whether the logical comparison of the value in cell B2 is greater than 50 (B2>50), but since it is 26 which is less than 50, Excel returns Fail in cell C2. Unlike the first example, False is replaced by Fail as it is written in the formula. In other words, Excel returns a False statement according to the IF formula.<\/p>\n

      The formula can be read, if a value in cell B2 is greater than 50, then Pass will be displayed (True), or if a value in cell B2 is less than 50, then Fail will be displayed (False).<\/p>\n

      Now, copy the formula in cell C2 and paste it to the remaining cells in the same column until cell C10 using the Fill Handle.<\/p>\n

      The Figure below shows all cells in column C have been filled with the formulas using the IF function.<\/p>\n

      \"image\"
      Figure 6.10 Copy the formula from cell C2 to the remaining cells in the same column<\/figcaption><\/figure>\n

      You can observe from the above Figure that cells C3, C5, C8, and C10 have Pass results since the scores are greater than 50 (>50) respectively. Cells C4, C6, C7, and C7 show the Fail results as the scores are less than 50.<\/p>\n

      In using the IF function, you can use the following logical operators to make the comparison in the logical test.<\/p>\n

      See below.<\/p>\n

      \n\n\n\n\n\n\n\n\n\n\n
      \n
      \n
      \n

      Operator<\/strong><\/p>\n<\/div>\n<\/div>\n<\/td>\n

      		\n
      \n

      Description<\/strong><\/p>\n<\/div>\n<\/td>\n<\/tr>\n

      \n
      \n

      =<\/p>\n<\/div>\n<\/td>\n

      		Equal to<\/td>\n<\/tr>\n
      \n
      \n

      <><\/p>\n<\/div>\n<\/td>\n

      		Not equal to<\/td>\n<\/tr>\n
      \n
      \n

      <<\/p>\n<\/div>\n<\/td>\n

      		Less than<\/td>\n<\/tr>\n
      \n
      \n

      ><\/p>\n<\/div>\n<\/td>\n

      		Greater than<\/td>\n<\/tr>\n
      \n
      \n

      <=<\/p>\n<\/div>\n<\/td>\n

      		Less than or equal to<\/td>\n<\/tr>\n
      \n
      \n

      >=<\/p>\n<\/div>\n<\/td>\n

      		Greater than or equal to<\/td>\n<\/tr>\n
      <\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

      The IF function lets you make informed decisions based on the data on the worksheet.<\/p>\n

      That\u2019s all for this Chapter.<\/p>\n

      You’re awesome!<\/p>\n<\/div>\n

      definition<\/span>