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
Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me determine what percentage of N11 is in I11. Thank you!



3 replies

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
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

0
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014

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
0
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014

Apr 8, 2014 at 12:28 PM
Ok, I take it back...I got it! Thank you TrowD for your help!
0