I think you have put your finger on it, Michael. The 2024.28 figure is calculated but displayed to only 2 decimal places. It is, to 4 decimal places, 2024.2829 which results in 295.5452888. So, thanks for the enlightenment!!
Cheers Harvey On Sat, 2018-12-29 at 05:11 +1000, Michael D. Setzer II wrote: > =With the updated first number I get the 295.54 as it should > be.</span> > Third position is a 4, it doesn't change the 2nd position. > > Num 1 > Num 2 > Num 1 * Num 2 > Rounded > 2024.28 > 0.146 > 295.54488 > 295.54 > > > Are the values you show for the Num 1 and Num 2 entered link that or > are > that what is displayed on screen.The actual numbers could throw off > the > calcs. > > > If the 0.146 number is display like that, but actually contains > 0.146001936490999 it would change the value. > > > > > On 28 Dec 2018 at 19:47, Harvey Nimmo wrote: > > > Subject:;Re: [libreoffice-users] Calc error?From:60;Harvey > [email protected]; > To:;Robert [email protected], > &# -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
