Applying a mathematical operation 

For this, we will fill the last column of our table with the TOTAL COST PER PART (USD), as indicated in the following table. This will show the total cost of purchasing the quantity needed for each individual part. To calculate the value, we can multiply the COST PER PART (USD) by the QTY.:

 To do this, we can follow these steps:

  1. Highlight the empty column at the far left by clicking the letter E at the top. Then, click on the Equation (Σ) command, as highlighted in the following screenshot:

  1. This will open the equation function, as shown in the following screenshot. In the equation space, we need to input the following: COST PER PART (USD)*QTY. Instead of typing all of this in the equation space, we can use the Columns drop-down menu. From there, we can select COST PER PART (USD). Then, we will notice that the column name was input in the equation space. After that, we can type * and select QTY. from the Columns drop-down menu:

  1. Click on the green checkmark to apply the equation. We will notice that the column was filled with numbers that are equal to the number under COST PER PART (USD), multiplied by QTY. To make the table more full, we can add a title to the column. The title can be TOTAL COST PER PART (USD). The final table will look as follows:

This concludes using multiplication. All the other operations, such as addition and subtraction, can be applied in the same way. Next, we will learn how to apply a function. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.14.253.152