formula

[chrisnsmith]

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?

 

[Pete_UK]

In G1:

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

Copy down as required.

Hope this helps.

Pete

 

[chrisnsmith]

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?

 

[Dana DeLouis]

me how to get it to return the number as a positive

even if it is a negative?

If there might be round-off errors, perhaps another idea...

=IF(ABS(A1 - B1 + C1 - D1 - E1 + F1) < 1E-10,ABS(A1+C1-E1),FALSE)

= = =
HTH :>)
Dana DeLouis

 

[chrisnsmith]

How can I get this formula to recognize blank cells as 0 (zero)?

 

[David Biddulph]

That formula *will* treat blank cells as zero.