Finding the difference...

[mike774u]

This is my problem.

I have 2 years.. 2006 and 2007 we will say column A is 2006 and C is
2007. Over in Column D I want to know the actual difference and if it
was greater or less than the previous year. If it was less I want it
to be a negative number. I was thinking it would be a =IF formula but
nothing I do seems to work.

Thank you loads for any help in advance anyone can provide.
Mike

 

[Roger Govier]

Hi

Just use
=C1-A1

If 2006 is less than 2007, it will be positive. If 2007 is less than 2006 it
will be negative.

 

[mike774u]

Wow, I seem to always forget the KISS theroy...Keep It Simple Stupid!
Thank you... using the custom cell format of "[Color10]$#,##0.00;[Red]
$#,##0.00;$#,##0.00" will change it to red for negitive and green for
positive.

THANKS!