Hi B, You should read these:
https://floating-point-gui.de/ https://www.volkerschatz.com/science/float.html https://randomascii.wordpress.com/category/floating-point/ https://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html There's a lot of information to digest, but until you understand it, you can't understand why numeric calculations behave as they do, or tell the difference between a bug and an unavoidable result. -- Steve _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list