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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i display a variance in all positive numbers?
"Susan" wrote:
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 =abs(A1-B1) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i display a variance in all positive numbers?
I am not sure if I understand what you are asking, but I will take a stab at it. I am assuming that both of the numbers are positive, (you can't have a negative operating margin, can you?) So you can simply do a =A1-B1 to get the difference, assuming column A is planned and column B is actual. If you want to difference to be a positive number, put a ABS before you formula, =ABS(A1-B1) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=555607 |
Reply |
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) |