| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i display a variance in all positive numbers?
I am working with a spreadsheet that has an operating margin and a planned
operating margin and some months I have a postive OM and some months a negative OM but when I display the variance between the two I'd like to display the variance as just a number, but automatic formating sometimes makes it a negative and sometimes a positive depending on which of the two numbers is largest. Can someone help me with this? thanks, Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using rounded numbers for display, but not for the calculation. | Excel Discussion (Misc queries) | |||
| how to add consecutive positive numbers | Excel Discussion (Misc queries) | |||
| How to remove page numbers from the display? | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| adding only positive numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
