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

=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

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

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: .

I hope that helps!