Home 
Search 
Today's Posts 
#1




Percentage formula in Excel spreadsheet
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(E14C14)/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 
#2




Percentage formula in Excel spreadsheet
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: =(E14C14)/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(E14C14)/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...o&userid=27741 View this thread: http://www.excelforum.com/showthread...hreadid=476535 
#3




Percentage formula in Excel spreadsheet
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" wrote in message ... 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(E14C14)/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 
#4




Percentage formula in Excel spreadsheet
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" wrote in message ... 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(E14C14)/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 
#5




Percentage formula in Excel spreadsheet
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" wrote in message news 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" wrote in message ... 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(E14C14)/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 
#6




Percentage formula in Excel spreadsheet
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(E14C14)/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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Formula for Returning values in another spreadsheet  Excel Worksheet Functions  
Excel Range Value issue (Excel 97 Vs Excel 2003)  Excel Discussion (Misc queries)  
Formula checking multiple worksheets  Excel Worksheet Functions  
Formula checking multiple worksheets  Excel Worksheet Functions  
Formatting percentage signs in Excel  Excel Discussion (Misc queries) 