formula
 

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?

formula
 

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?

formula
 

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?

formula
 

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 wrote:
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?

formula
 

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

"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?

formula
 

That formula *will* treat blank cells as zero.
--
David Biddulph

"chrisnsmith" wrote in message
...
How can I get this formula to recognize blank cells as 0 (zero)?

"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?