Hello! To calculate percentage in excel the fornula is percentage = total marks obtained * 100 / total marks
suppose there is marksheet of 6 subjects 100 marks each written from a3 to f3 than a3 contains 90 b3 contains 40 c3 contains 60 d3 contains 50 e3 contains 95 f3 contains 85 sum formula in g3 =sum(a3:f3) than, total marks obtained: 420 from 600 (100 multiply by 6) percentage formula in h3 =g3*100/600 percentage will be 70 Thanks With Regards Vinita Jajodiya -----Original message----- From: Mahesh Narasimhan Sent: 27/03/2013, 9:25 pm To: accessindia@accessindia.org.in Subject: Re: [AI] Formula required to caliculate percentage. Dear Srinivas, I am forced to assume that the data which you have is of Individual Series. Since the data is from A1 to F1, firstly you need to calculate the total of the series and the formula to calculate total is =SUM(A1:F1) and press Enter Key. Calculate the total in G1 cell. Now to calculate the percentage of the series, go to A2 and use the formula, =(A1/value of G1)*100 and press Enter Key. Here the value of G1 means the numeric value of the cell G1. If you want to copy the formula to different cells also, then come to cell A2 and copy by using Control+C and by using Shift Key and Right Arrow, you come to F2 and paste by using Control+V and press Enter Key. Example: Before the : sign is the cell reference and after the : sign is the numeric value of the cell. A1: 22, B1: 37, C1: 29, D1: 41, E1: 35, F1: 26. Total from A1 to F1 is 190. Come to A2 cell and use the formula =(A1/190)*100 and press Enter Key. The numeric value of A2 is the percentage of the series. Then come to A2 cell and copy and select by pressing the Shift Key and right arrow till F2 and paste and press Enter Key. Note the total of the percentage of the series will be 100. Just test it. Come to cell G2 and use the formula =Sum(A2:F2) and press Enter Key and the numeric value of G2 will be 100. Hope its clear now. -- Good friendship is like the relationship between eye & hand! If the hand is hurt, the eye will cry! & when the eye cries, the hand will wipe the tears!!! With best regards, Mahesh Narasimhan Iyer Mobile #: +91 9899353960 E-Mails: maheshde...@gmail.com, mahesh_de...@rediffmail.com Skype: maheshdel88 On 3/27/13, srinivas bangalore_11 <srinivas.bangalor...@gmail.com> wrote: > Hi team, > I am in need of a formula for percentage to caliculate in excel. > > Please help me in this regard. > > With best regards, > Srinivas MVLES. > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
