Re: [libreoffice-users] Calc error? SOLVED

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
> Nimmoharvey@nimmo.det;
> To:;Robert Grokopfrobert@familiegrosskopf.de,
> &#
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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