Determine percentage via formula
Solved/Closed
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
-
Apr 8, 2014 at 11:53 AM
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - Apr 8, 2014 at 12:28 PM
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - Apr 8, 2014 at 12:28 PM
Related:
- Determine percentage via formula
- Excel marksheet percentage formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 8, 2014 at 12:04 PM
Apr 8, 2014 at 12:04 PM
Hi Kaiwalls04,
To remember how to do percentage calculations, start with easy numbers.
N11 = 100
I11 = 50
Now it is easy to say N11 is twice as big as I11 or 200%.
How do we got there?: 100/50*100%
So to answer your question: =N11/I11*100
Best regards,
Trowa
To remember how to do percentage calculations, start with easy numbers.
N11 = 100
I11 = 50
Now it is easy to say N11 is twice as big as I11 or 200%.
How do we got there?: 100/50*100%
So to answer your question: =N11/I11*100
Best regards,
Trowa
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
Apr 8, 2014 at 12:21 PM
Apr 8, 2014 at 12:21 PM
while I understand the basic math, what is getting me is this. Why is my percentage way over 100? This is what I need. If
A B C D E G
1912542 698050 57588 271781 481860 3421821
(Where A, B, C, D, and E total G), what I need is a formula to show the percent of A through E that totals G. I know this is crazy simple, but for the life of me I can't get it today! lol
A B C D E G
1912542 698050 57588 271781 481860 3421821
(Where A, B, C, D, and E total G), what I need is a formula to show the percent of A through E that totals G. I know this is crazy simple, but for the life of me I can't get it today! lol
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
Apr 8, 2014 at 12:28 PM
Apr 8, 2014 at 12:28 PM
Ok, I take it back...I got it! Thank you TrowD for your help!
