# 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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
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%

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
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
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!