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.
|