absolute values | Message 43 of 43 | TechRepublic

Discussion on:

Office challenge: When an IF() returns FALSE, when it should return TRUE

View entire thread

Message 43 of 43

« Prev

0 Votes

+ -

absolute values

Sometimes, it's the format of the cell (general, text, etc.), so if you use the absolute value of the cell ABS(A4) compared to ABS(B4), it will match. This has been the case every time I've had this problem.

Posted by marj@...

4th Jan 2012