{"id":54,"date":"2023-12-14T01:46:22","date_gmt":"2023-12-14T01:46:22","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-2-creating-formulas\/"},"modified":"2024-09-18T00:51:48","modified_gmt":"2024-09-18T00:51:48","slug":"chapter-2-creating-formulas","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-2-creating-formulas\/","title":{"raw":"Chapter 2: Formula Basics","rendered":"Chapter 2: Formula Basics"},"content":{"raw":"
\r\n
\r\n

Learning Objectives<\/h4>\r\n<\/header>\r\n
\r\n
    \r\n \t
  1. Adjust a column width.<\/li>\r\n \t
  2. Identify mathematical operators used in Excel<\/li>\r\n \t
  3. Create formulas using mathematical operators.<\/li>\r\n \t
  4. Edit a formula.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<\/div>\r\n

    Knowing how to create [pb_glossary id=\"174\"]formulas[\/pb_glossary] in Excel is mandatory. Formulas always start with an equal sign (=), which can be followed by a combination of numbers, cell references, mathematical operators, or functions. In this chapter, you will learn how to create basic Excel formulas using numbers and one of the following mathematical operators.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
    \r\n

    + (plus sign) for addition<\/p>\r\n<\/td>\r\n<\/tr>\r\n

    \r\n

    - (minus sign) for subtraction<\/p>\r\n<\/td>\r\n<\/tr>\r\n

    \r\n

    * (asterisk) for multiplication<\/p>\r\n<\/td>\r\n<\/tr>\r\n

    \r\n

    \/ (forward slash) for division<\/p>\r\n<\/td>\r\n<\/tr>\r\n

    \r\n

    % (percent sign) for percent<\/p>\r\n<\/td>\r\n<\/tr>\r\n

    \r\n

    ^ (caret) for exponentiation<\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

    Let\u2019s go!<\/p>\r\n

    Create a new blank workbook. Type the following contents in their respective cells as shown in the Figure below. Use the default font and size.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.1 Type the contents in their respective cells as shown.[\/caption]\r\n

    You will notice that one content in cell J27 overflows to the next cell in the next column. For your information, the default column size is 8.09 points or 96 pixels. Therefore, longer contents may flow into the next cell in the next column. To remedy this, we need to expand the width of column J. Bring your mouse pointer to the boundary in between column J and column K. Once the mouse pointer changes its shape to double-arrow, quickly hold your mouse button and drag it to the right to increase the width of column J.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.2 Drag the mouse button to the right to increase the width of column J.[\/caption]\r\n

    When all contents in column J fit, then you can release the mouse button. Now you shall see the width of column J is longer or bigger than the widths of other columns.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.3 All contents should fit in column J.[\/caption]\r\n

    It is important to note that all contents are still in column J whether you expand the column width or not. However, for a better visual, it is recommended to expand the column width.<\/p>\r\n

    The other method to quickly expand the column width is to just double-click at the boundary, in this case, the boundary between column J and column K. Excel will adjust the width of column J automatically.<\/p>\r\n

    Now, type Formula Result in cell L24. Later, expand column L to fit the text.<\/p>\r\n

    Bold the contents in cell J24 and cell K24.<\/p>\r\n

    At this point, your worksheet should be as in the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1377\"]\"image\" Figure 2.4 The widths of column J and column K have been expanded.[\/caption]\r\n

    Now, save your workbook with your preferred name and in any location on your computer.<\/p>\r\n

    Let\u2019s create the first formula.<\/p>\r\n

    In this formula, we will use a plus symbol, (+) to add the values of two numbers, 1000 and 200.<\/p>\r\n

    In cell K25, create a formula to calculate 1000+200. Remember, an Excel formula should start with an equal sign (=). Type =1000+200 in cell K25, then press Enter. This is a very basic and straightforward formula just to show the use of a mathematical operator, a plus sign (+) for addition.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.5 Begin the formula with an equal sign, (=) followed by the numbers.[\/caption]\r\n

    After typing the formula, press Enter to let Excel perform the calculation, 1000 + 200, and display the result in cell K25. As expected, Excel will display 1200 in cell K25. This is the formula result.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.6 Press Enter to get the formula result.[\/caption]\r\n

    If you want to check or edit the formula, click cell K25 and the formula should be displayed in the Formula Bar. Double-click cell K25 to edit the formula if necessary.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.7 Click cell K25 to check the formula in the Formula Bar.[\/caption]\r\n

    At this stage, you should be able to understand the basic formula structure. The formula you have just created in cell K25 begins with an equal sign, (=) followed by the combination of two numbers and a plus sign, (+) for addition.<\/p>\r\n

    Now, by referring to the table that contains mathematical operators given at the beginning of this chapter, create a formula for each operation below.<\/p>\r\n

    In cell K26, type =1000-50 as a formula to calculate 1000 \u2013 50.<\/p>\r\n

    In cell K27, type =1000-50 as a formula to calculate 2 x 200.<\/p>\r\n

    In cell K28, type =1000\/50 as a formula to calculate 1000 \u00f7 50.<\/p>\r\n

    In cell K29, type 1000*50% as a formula to calculate 1000 x 50%.<\/p>\r\n

    In cell K30, type =2^3 as a formula to calculate 23<\/sup>.<\/sup><\/p>\r\n

    The following figure shows the formula results.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 2.8 The formula results for cells K26, K27, K28, K29 and K30.[\/caption]\r\n

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

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

    \n
    \n
    \n

    Learning Objectives<\/h4>\n<\/header>\n
    \n
      \n
    1. Adjust a column width.<\/li>\n
    2. Identify mathematical operators used in Excel<\/li>\n
    3. Create formulas using mathematical operators.<\/li>\n
    4. Edit a formula.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

      Knowing how to create formulas<\/a> in Excel is mandatory. Formulas always start with an equal sign (=), which can be followed by a combination of numbers, cell references, mathematical operators, or functions. In this chapter, you will learn how to create basic Excel formulas using numbers and one of the following mathematical operators.<\/p>\n\n\n\n\n\n\n\n\n
      \n

      + (plus sign) for addition<\/p>\n<\/td>\n<\/tr>\n

      \n

      – (minus sign) for subtraction<\/p>\n<\/td>\n<\/tr>\n

      \n

      * (asterisk) for multiplication<\/p>\n<\/td>\n<\/tr>\n

      \n

      \/ (forward slash) for division<\/p>\n<\/td>\n<\/tr>\n

      \n

      % (percent sign) for percent<\/p>\n<\/td>\n<\/tr>\n

      \n

      ^ (caret) for exponentiation<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      Let\u2019s go!<\/p>\n

      Create a new blank workbook. Type the following contents in their respective cells as shown in the Figure below. Use the default font and size.<\/p>\n

      \"image\"
      Figure 2.1 Type the contents in their respective cells as shown.<\/figcaption><\/figure>\n

      You will notice that one content in cell J27 overflows to the next cell in the next column. For your information, the default column size is 8.09 points or 96 pixels. Therefore, longer contents may flow into the next cell in the next column. To remedy this, we need to expand the width of column J. Bring your mouse pointer to the boundary in between column J and column K. Once the mouse pointer changes its shape to double-arrow, quickly hold your mouse button and drag it to the right to increase the width of column J.<\/p>\n

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

      \"image\"
      Figure 2.2 Drag the mouse button to the right to increase the width of column J.<\/figcaption><\/figure>\n

      When all contents in column J fit, then you can release the mouse button. Now you shall see the width of column J is longer or bigger than the widths of other columns.<\/p>\n

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

      \"image\"
      Figure 2.3 All contents should fit in column J.<\/figcaption><\/figure>\n

      It is important to note that all contents are still in column J whether you expand the column width or not. However, for a better visual, it is recommended to expand the column width.<\/p>\n

      The other method to quickly expand the column width is to just double-click at the boundary, in this case, the boundary between column J and column K. Excel will adjust the width of column J automatically.<\/p>\n

      Now, type Formula Result in cell L24. Later, expand column L to fit the text.<\/p>\n

      Bold the contents in cell J24 and cell K24.<\/p>\n

      At this point, your worksheet should be as in the Figure below.<\/p>\n

      \"image\"
      Figure 2.4 The widths of column J and column K have been expanded.<\/figcaption><\/figure>\n

      Now, save your workbook with your preferred name and in any location on your computer.<\/p>\n

      Let\u2019s create the first formula.<\/p>\n

      In this formula, we will use a plus symbol, (+) to add the values of two numbers, 1000 and 200.<\/p>\n

      In cell K25, create a formula to calculate 1000+200. Remember, an Excel formula should start with an equal sign (=). Type =1000+200 in cell K25, then press Enter. This is a very basic and straightforward formula just to show the use of a mathematical operator, a plus sign (+) for addition.<\/p>\n

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

      \"image\"
      Figure 2.5 Begin the formula with an equal sign, (=) followed by the numbers.<\/figcaption><\/figure>\n

      After typing the formula, press Enter to let Excel perform the calculation, 1000 + 200, and display the result in cell K25. As expected, Excel will display 1200 in cell K25. This is the formula result.<\/p>\n

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

      \"image\"
      Figure 2.6 Press Enter to get the formula result.<\/figcaption><\/figure>\n

      If you want to check or edit the formula, click cell K25 and the formula should be displayed in the Formula Bar. Double-click cell K25 to edit the formula if necessary.<\/p>\n

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

      \"image\"
      Figure 2.7 Click cell K25 to check the formula in the Formula Bar.<\/figcaption><\/figure>\n

      At this stage, you should be able to understand the basic formula structure. The formula you have just created in cell K25 begins with an equal sign, (=) followed by the combination of two numbers and a plus sign, (+) for addition.<\/p>\n

      Now, by referring to the table that contains mathematical operators given at the beginning of this chapter, create a formula for each operation below.<\/p>\n

      In cell K26, type =1000-50 as a formula to calculate 1000 \u2013 50.<\/p>\n

      In cell K27, type =1000-50 as a formula to calculate 2 x 200.<\/p>\n

      In cell K28, type =1000\/50 as a formula to calculate 1000 \u00f7 50.<\/p>\n

      In cell K29, type 1000*50% as a formula to calculate 1000 x 50%.<\/p>\n

      In cell K30, type =2^3 as a formula to calculate 23<\/sup>.<\/sup><\/p>\n

      The following figure shows the formula results.<\/p>\n

      \"image\"
      Figure 2.8 The formula results for cells K26, K27, K28, K29 and K30.<\/figcaption><\/figure>\n

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

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

      definition<\/span>