Re: [libreoffice-users] a little math problem with Calc

Hi.
In fact if I change your function
r(3)=(r(2)-18)*1000000000
Test = r(3)

the result is -2.8421709430404E-005
showing that 17 would be correct.

For these situations I often add my own tolerance to limit sensitivity
r(3)=int(r(2)+1e-9)

steve

On 5/07/12 1:50 PM, alex sato wrote:
> Hi,
>
> I have a problem with functions I made.
>
> Let's say I create the function:
>
> Function Test (n)
> dim r(3)
> r(0)=int(n)
> r(1)=n-r(0)
> r(2)=r(1)*100
> r(3)=int(r(2))
> Test = r
> End Function
>
> Then, in a empty spreadsheet take the following steps:
> -select A1:D1
> -press [F2]
> -Insert the formula =TEST(E1)
> -press [CTRL]+[SHIFT]+[ENTER]
> -insert 11,18 in E1 and see the result in cell D1
>
> I think the result should be 18 but I'm getting 17
> Where is the error?
>
> By the way, I downloaded and installed the latest version of LibreOffice
> before write this email to make sure that is not a solved bug. And I tried
> this at least in 3 computers.
>
> Thanks in Advance
>
> Alex Mitsio Sato

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted