Calculation with percentage of completion - Formulas In Excel - Microsoft Excel Tutorials

26.  Calculation with percentage

Let’s say you want to buy a new car. The listed price of the car is $25,500, and the tax to be added is 8%. After negotiating a sales discount of 10%, the final price has to be calculated.

To calculate the final price:

1. Select cell B1 and enter 25500.
2. Select cell B2 to enter the tax rate of 8%.
3. Select cell B3 and enter the discount rate of 10%.
4. Select cell B5 and type the following formula: =B1*(1+B2)*(1-B3).

Note: As you see in cell C5 in Figure 1-26, the formula =B1*(1–B3)*(1+B2) also works. The order of multiplication does not matter.

Watch the Video Tutorial - https://www.youtube.com/watch?v=efqUK_onU7c

 

Hope You Like This Tutorial - Give Comments