On Dec 27, 1:46*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Wouldn't it be better to have
=If(ROUND(A4-X,3)=0,"ok",X-A4)
*rather than
=If(ROUND(A4,3)=X,"ok",X-A4) ?

Good point, and probably right.

This might be especially true when comparing results on either side of
zero. Remember that ROUND() goes away from zero. So rounding each
operand on either side of zero might increase the distance, whereas
rounding their difference might be a truer result.