Hi i have downloaded data in cells A1 A2 A3 A4 .
9669.86
9669.62
9669.62
9669.51
this formula in B1
=AND((A1-A2)>(A3-A4)).
in evaluate formula it is showing like this
=AND(0.23999999999782>0.110000000001582)
=TRUE.
how to remove this invisible decimal calculation?
actually it should calculate like this
=AND((9669.86-9669.62)>(9669.62-9669.51))
=AND(0.24>0.11)
=TRUE.
Bookmarks