Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to show the difference between costings for last month, compared
with this month. For example, last month a particular costing showed a profit of $100. This month is showing a loss of -$200. I need to show that this month the difference between the costings is therefore -$100, or, $100 dollars less than last month. Can anyone offer me the formula to do this? Sneaky second question!... it would be useful to display, in the above example, "$100 less", rather than "-$100". Can this be done? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to turn positive to negative values in excel | Excel Worksheet Functions | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
Sumif using dates and positive negative values | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
switching values from positive to negative | Excel Worksheet Functions |