Rick

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for Returning values in another spreadsheet	lrbest4x4xfar	Excel Worksheet Functions	1	October 14th 05 02:52 PM
Excel Range Value issue (Excel 97 Vs Excel 2003)	Keeno	Excel Discussion (Misc queries)	2	June 13th 05 02:01 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Formatting percentage signs in Excel	Romany	Excel Discussion (Misc queries)	3	June 1st 05 07:02 PM

All times are GMT +1. The time now is 07:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us