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
|
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:
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! |
=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 |
All times are GMT +1. The time now is 02:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com