| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
| CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
