Closest To Zero

[milwphil]

Is there a formula that I can use to determine if a cell is closer to zero than another cell (comparing the two) and then enter either "Yes" or "No"

For example: The data being compared is in Column A and B. If Column B is closer to zero than "No", if Column A is closer to Zero than "Yes."

Using less than doesn't work because of the negative numbers.

Column
A | B | C
-1 | -2 | Yes
-5 | -2 | No
2 | 1 | No
1 | 2 | Yes

Thanks in advance!

 

[Joe4]

You can make use of the Absolute Value (ABS) function:

=IF(ABS(A1) < ABS(B1),"Yes","No")

 

[Aladin Akyurek]

Is there a formula that I can use to determine if a cell is closer to zero than another cell (comparing the two) and then enter either "Yes" or "No"

For example: The data being compared is in Column A and B. If Column B is closer to zero than "No", if Column A is closer to Zero than "Yes."

Using less than doesn't work because of the negative numbers.

Column
A | B | C
-1 | -2 | Yes
-5 | -2 | No
2 | 1 | No
1 | 2 | Yes

Thanks in advance!

Try...

=IF(A2 = B2, "Both", IF(ABS(A2) < ABS(B2), "Yes", "No"))

 

[milwphil]

I think that'll do the trick!!! THANK YOU SO MUCH! I've never used ABS.