Re: Rounding in LiveCode vs Excel

Just to follow up on the rounding issue: Panos has now confirmed that round(5,-1) = 0 is indeed a bug, since at least LC 6(!!!): https://quality.livecode.com/show_bug.cgi?id=23522 /Andreas ___ use-l

Re: Rounding in LiveCode vs Excel

> Will using "statround()" instead of "round()" give you an Excel-comparable > outcome? Unfortunately not, I tried that too. /Andreas ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manag

Re: Rounding in LiveCode vs Excel

Will using "statround()" instead of "round()" give you an Excel-comparable outcome? Phil Davis On 1/9/22 12:49 PM, Andreas Bergendal via use-livecode wrote: Hi all, TLDR; In LC: round(0.5,0) = 1 (Excel agrees) round(5,-1) = 0 (Excel disagrees and makes that 10!) I agree with Excel, I want

Re: Rounding in LiveCode vs Excel

Andreas, thanks this is very interesting and super good to know. Seems a little bit important. Thanks, following this thread. On Sun, Jan 9, 2022 at 3:50 PM Andreas Bergendal via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi all, > > TLDR; > > In LC: > round(0.5,0) = 1 (Excel agrees)

Rounding in LiveCode vs Excel

Hi all, TLDR; In LC: round(0.5,0) = 1 (Excel agrees) round(5,-1) = 0 (Excel disagrees and makes that 10!) I agree with Excel, I want the latter rounded to 10, not 0. Is LC doing it ’wrong’ and if so, why? Long version: I’m building software for a client that will do some calculations that a