Finding the difference...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike774u@gmail.com - 08 Dec 2007 00:17 GMT

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

Reply to this Message

Roger Govier - 08 Dec 2007 00:24 GMT

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.

Signature

Regards
Roger Govier

> This is my problem.
>
[quoted text clipped - 6 lines]
> Thank you loads for any help in advance anyone can provide.
> Mike

Reply to this Message

mike774u@gmail.com - 08 Dec 2007 00:45 GMT

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!

Reply to this Message