% of change when some numbers are negative
 

I am using a spreadsheet to calculate a comparison of ytd results versus last
ytd results. If one or both numbers are negative (as in the case of profits)
I am having no luck at all in getting the correct % of improvement.

As an example: Cell C1 = (3,624.00) Prior YTD Profit
Cell D1 = (6,712.00) Current YTD Profit
Cell E1 = (3,088.00) (Additional Loss)
Cell F1 = 85.2% (A positive % Indicating an
Improvement)


Numbers in this spreadsheet May be negative for prior YTD, Positive for
Current YTD, vise versa, or Both May be negative.

Any help on this would be greatly appreciated.


Thanks
--
Sam Fowler

% of change when some numbers are negative
 

Try: =E2/ABS(C2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sam Fowler" wrote in message
...
I am using a spreadsheet to calculate a comparison of ytd results versus
last
ytd results. If one or both numbers are negative (as in the case of
profits)
I am having no luck at all in getting the correct % of improvement.

As an example: Cell C1 = (3,624.00) Prior YTD Profit
Cell D1 = (6,712.00) Current YTD Profit
Cell E1 = (3,088.00) (Additional Loss)
Cell F1 = 85.2% (A positive % Indicating an
Improvement)


Numbers in this spreadsheet May be negative for prior YTD, Positive for
Current YTD, vise versa, or Both May be negative.

Any help on this would be greatly appreciated.


Thanks
--
Sam Fowler

% of change when some numbers are negative
 

what do you want the results to be for
C1=0,D1<0
C1<0,D1<C1
C1<0,D1<0,D1c1
C1<0,D10
C10,D1<0
C10,D10

"Sam Fowler" wrote:

I am using a spreadsheet to calculate a comparison of ytd results versus last
ytd results. If one or both numbers are negative (as in the case of profits)
I am having no luck at all in getting the correct % of improvement.

As an example: Cell C1 = (3,624.00) Prior YTD Profit
Cell D1 = (6,712.00) Current YTD Profit
Cell E1 = (3,088.00) (Additional Loss)
Cell F1 = 85.2% (A positive % Indicating an
Improvement)


Numbers in this spreadsheet May be negative for prior YTD, Positive for
Current YTD, vise versa, or Both May be negative.

Any help on this would be greatly appreciated.


Thanks
--
Sam Fowler