HOW TO CALCULATE and ADD RUNNING PERCENTAGE formula IN EXCEL
Loading...
Uploaded by tiktam51 on Oct 23, 2009
The same way u can Subtract
just put (-) sign to subtract.
- SIGN to subtract
+SIGN to add
* MULTIPLY
/ DIVIDE
SOME FORMULAS:
=sum(B4:B16)-sum(B19:B25)
This formula will add up the contents of cells B4 to B16.
It will also add up the contents of cells B19 to B25 as a
separate calculation and then subtract the answer it got
from adding up cells B19 to B25 from the answer it got
from adding up the contents of cells B4 to B16.
=sum(B3:B6)*75%
This formula will add up the contents of cells B3 to B6
and then multiply the resulting sum by 75%.
=sum(B2:B18)-B20
This formula will add up the contents of
cells B2 to B18 and then subtract the value
of B20 from its answer
=(B3*2.5%)+B3
This formula will calculate 2.5% of the value of
cell B3 and then add that calculation to the original
amount in B3.
Link to this comment:
Uploader Comments (tiktam51)
All Comments (9)
-
this does not work for me, when i drag the plus arrow, it all comes up with the same number, frustrating
-
I want to find out how to calculate PERCENTAGE!!! as your video title said...
-
Thanks so much! I couldn't figure out how to do percentages and was about to destroy my computer. Because of you I was able to complete my homework!
-
Your video is very good
and helped me in my work
was what I was looking Thank you
5:15Excel Basic Formulas: Sum and Percentageby goaskdebbie12,073 views
- 4:21Excel - Formulas for Percentageby hwilmer9,073 views
- 2:08Calculate Percentage of Totalby MrExcel312,139 views
- 1:40Excel - using AutoSumby skillsforchangetv2,128 views
- 1:24Learn how to use percentage in Excelby UseITTraining3,764 views
- 9:20How to add subtract multiply and divide using M...by Jaymz2818,850 views
- 9:21Data Entry Trainingby bowietke7,861 views
- 3:21Smart Payroll Timesheet Setupby sivnan19,737 views
- 8:13How Does Excel Calculate Time?by DannyRocksExcels21,227 views
- 1:49Excel 2010 - Add, subtract, multiply, and divideby InAMinuteLearning14,549 views
- 3:56Excel 2010 - Percentagesby classroommultimedia5,178 views
- 0:33How to apply a formula to selected cells in Excelby asaputilities14,896 views
- 11:37Excel Sum Percentage multiply Formulaby TheKatr212,635 views
- 7:31Excel Magic Trick 480: Percentage Of Total - Fo...by ExcelIsFun18,642 views
- 4:28Excel Basics #13: Percentage Number Formatby ExcelIsFun33,949 views
- 1:09M18(2) How to calculate percentages and absolut...by maggieverster3,196 views
- 0:57How To Calculate Percentageby Howcast41,935 views
- 8:39Microsoft Excel Tutorial for Beginners #15 - Pe...by MotionTraining51,922 views
- 7:43Calculate percentages with mental math - video ...by MathMammoth44,694 views
- 4:27Excel Statistics 07: Calculate Proportions and ...by ExcelIsFun21,435 views
It s absolutely not clear what the author is trying to show in this video.
dooric 1 year ago 4
@dooric This is calculating running percentage do it ur self in excel as shown here and u will understand or u can make ur tutorial no problem.
tiktam51 1 year ago
Can you let me know what the music is?
And thanks for the % advice it works a treat.
Cheers
TheSleeveMusicShow 1 year ago
The music is from Audio Swap from this
site and is not showing up
when i click Statistics & Data
so it's difficult to tell at present
tiktam51 1 year ago