Percentage formula in Excel spreadsheet in Excel New users    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Rick 10/15/2005 12:20 PM PST   Question   Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - C14. In G14 I have put a formula to show the difference between E14 and C14 as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up the column. Does anyone know how to solve this problem. Many thanks for looking. Rick     Was this post helpful to you?         Reply |   Top           CLR 10/15/2005 1:48 PM PST   Answer   I just duplicated your description of your situation in XL2k, including copy and paste your G14 formula, and it all seems to work fine.........perhaps a typo on your spreadsheet? Vaya con Dios, Chuck, CABGx3 "Rick" <Rick@discussions.microsoft.com> wrote in message news:F7CC32EF-61CA-4FC8-9528-603715AB567D@microsoft.com... > Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - > C14. In G14 I have put a formula to show the difference between E14 and C14 > as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the > Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up > the column. Does anyone know how to solve this problem. Many thanks for > looking. Rick     Was this post helpful to you?         Reply |   Top           Rick 10/15/2005 1:56 PM PST   Don't know what was wrong but I did the formula again and this time it worked, although the percentage answer was a couple of points out it is close enough. Thanks again. Rick "CLR" wrote: > I just duplicated your description of your situation in XL2k, including copy > and paste your G14 formula, and it all seems to work fine.........perhaps a > typo on your spreadsheet? > > Vaya con Dios, > Chuck, CABGx3 > > > > "Rick" <Rick@discussions.microsoft.com> wrote in message > news:F7CC32EF-61CA-4FC8-9528-603715AB567D@microsoft.com... > > Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - > > C14. In G14 I have put a formula to show the difference between E14 and > C14 > > as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When > the > > Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add > up > > the column. Does anyone know how to solve this problem. Many thanks for > > looking. Rick > > >     Was this post helpful to you?         Reply |   Top           CLR 10/15/2005 2:06 PM PST   Glad you got it working..........I make those kind of typo's all the time............remember, "The only people that don't make mistakes, are those that don't DO anything"......... Vaya con Dios, Chuck, CABGx3 "Rick" <Rick@discussions.microsoft.com> wrote in message news:D0526AEB-2ED9-4E0A-8440-651E7C7C3685@microsoft.com... > Don't know what was wrong but I did the formula again and this time it > worked, although the percentage answer was a couple of points out it is close > enough. Thanks again. Rick > > "CLR" wrote: > > > I just duplicated your description of your situation in XL2k, including copy > > and paste your G14 formula, and it all seems to work fine.........perhaps a > > typo on your spreadsheet? > > > > Vaya con Dios, > > Chuck, CABGx3 > > > > > > > > "Rick" <Rick@discussions.microsoft.com> wrote in message > > news:F7CC32EF-61CA-4FC8-9528-603715AB567D@microsoft.com... > > > Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - > > > C14. In G14 I have put a formula to show the difference between E14 and > > C14 > > > as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When > > the > > > Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add > > up > > > the column. Does anyone know how to solve this problem. Many thanks for > > > looking. Rick > > > > > >     Was this post helpful to you?         Reply |   Top           Lilliabeth 10/15/2005 2:09 PM PST   Not sure I understand the problem; tell us what answer or error you are getting. Also, don't you mean you are summing C2:C*13* in C14 and E2:E*13* in E14? Oh, and you can get rid of the Sum - this is all you need: =(E14-C14)/ABS(E14) Rick Wrote: > Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 > - > C14. In G14 I have put a formula to show the difference between E14 > and C14 > as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). > When the > Formula for G14 looks at E14 and C14 all it sees is a SUM formula to > add up > the column. Does anyone know how to solve this problem. Many thanks > for > looking. Rick -- Lilliabeth ------------------------------------------------------------------------ Lilliabeth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27741 View this thread: http://www.excelforum.com/showthread.php?threadid=476535     Was this post helpful to you?         Reply |   Top           peachez 11/9/2008 8:29 PM PST   I have a problem and I need to multiply the three colums individually first and in the next category I am required to give the total. How do I set uo my cormula? Peazhez "Rick" wrote: > Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - > C14. In G14 I have put a formula to show the difference between E14 and C14 > as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the > Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up > the column. Does anyone know how to solve this problem. Many thanks for > looking. Rick     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies