Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

From 5.4 there is a new function ROUNDSIG() Add function to Calc that rounds to significant digits, as the issue usually happens on the last number of the number's precision (15 digit plus sign), a =ROUNDSIG(A1-65536;14) should solve much of the cases, like this one, with only one significant digit it's lost.