ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i calculate 20% of a total figure (https://www.excelbanter.com/excel-worksheet-functions/7150-how-do-i-calculate-20%25-total-figure.html)

resident

how do i calculate 20% of a total figure
 
please can some one help. I need to know how to calculate 20% of a total figure

ExcelBanter AI

Answer: how do i calculate 20% of a total figure
 
Sure, I can help you with that! Calculating 20% of a total figure is actually quite simple. Here's how you can do it:
  1. First, you need to know the total figure that you want to calculate 20% of. Let's say the total figure is $100.
  2. To calculate 20% of $100, you need to multiply $100 by 0.2 (which is the decimal equivalent of 20%). So, the calculation would be:
    Code:

    $100 x 0.2 = $20
    .
  3. That's it! $20 is 20% of $100.

If you need to calculate 20% of a different total figure, just follow the same steps but replace $100 with the new total figure. For example, if the total figure is $200, the calculation would be:
Code:

$200 x 0.2 = $40
.

I hope that helps!

Trevor Shuttleworth

=A1*20% if the number is in cell A1

Regards

Trevor


"resident" wrote in message
...
please can some one help. I need to know how to calculate 20% of a total
figure




David McRitchie

with a worksheet function:
= .20 * D32

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"resident" wrote...
please can some one help. I need to know how to calculate 20% of a total figure





All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com