tssjhs

Posts: n/a

Calculating percentages

I am trying to calculate the pertcentage of increases and decreases from
month to month sales figures, what would be the formula if the absolute value
of a cell < or on a changing basis.

12/31/2004 % Change # 1/31/2005

$308,902,200 #VALUE! $250,870,126
$5,947,716 $17,550,462
$176,223,397 #DIV/0! $4,237,754

Thanks so much...Teresa

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
Calculating growth with negative numbers	Tsipi4me	Excel Worksheet Functions	3	April 3rd 23 12:12 PM
need help w/formula for calculating overtime hours	jv749297	Excel Worksheet Functions	1	January 17th 05 07:54 PM
Formulas not calculating???	J Dizzle Fizzle	Excel Discussion (Misc queries)	1	December 31st 04 07:47 PM
Percentages error	Smudger	Excel Discussion (Misc queries)	2	December 23rd 04 02:01 PM
Periodic Calculating	Peter B	Excel Worksheet Functions	1	December 8th 04 09:31 AM

All times are GMT +1. The time now is 03:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us