Let me know if you have any doubts regarding this excel topic or any other. You might also want to calculate the percentage change from one month to the next month. The result is 08 which is then multiplied by the price of the cellphone in cell B2 1409908.
Assuming that the total value is in cell A2 and percent in B2 the above formula turns into a simple A2B2 and returns 10450.
Say that your company sold 125000 this quarter and you need to find out what percentage 20000 is of the total. First Excel will calculate the formula 1-C2. It is split into two parts one is 10 days in hometown and 5 days in the USA. The math to determine a percentage is to divide the numerator the number on top of the fraction by the denominator the number on the bottom of the fraction then multiply the answer by 100.