Home |
Search |
Today's Posts |
#1
|
|||
|
|||
difference between two cells
Looking to find the correct formula to find the difference between two cells. For further clarification, this is the closing price (of a stock) on one day versus the opening price the next day, so I am looking to see what the difference is and if it is negative or positive.
For example - I have used: = IF(B34C33, (B34-C33), (C33-B34) ) which seems to work just fine except that the result, when a negative value, is not shown as such.(no minus sign) I would like to display any negative values in red with a minus sign. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between two cells
Hi,
Am Mon, 7 Jul 2014 16:10:11 +0100 schrieb jeromeUAE: Looking to find the correct formula to find the difference between two cells. For further clarification, this is the closing price (of a stock) on one day versus the opening price the next day, so I am looking to see what the difference is and if it is negative or positive. =C33-B34 and format as number with red negative values Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to work out the difference in 2 cells. | Excel Worksheet Functions | |||
calculate the difference between two cells | Excel Discussion (Misc queries) | |||
Getting Difference between two cells | Excel Worksheet Functions | |||
Difference between Cells | Excel Worksheet Functions | |||
Finding difference between two cells | Excel Programming |