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