Thanks Pete, the formula does just what I wanted, but can you tell me how to
get it to return the number as a positive even if it is a negative?

"Pete_UK" wrote:

In G1:

=IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE")

Copy down as required.

Hope this helps.

Pete

On Jan 28, 2:06 am, chrisnsmith
wrote:
I need to do the following.
Column A+C-E=
Column B+D-F=
Compare these formulas and if the answer is the same post the answer in
column G,if < than 0, if not say false.
How do I do this?