Right. Excel seems to have no limit on the number of places you can
round to. I tried 600 and it worked (I think). It seems that Excel won't
calculate beyond fourteen decimals. I entered 20/3 and got
6.6666666666666700000000 when the cell was formatted to display 22
decimal places. Rounding to more that 20 places seems to me to be not
rounding. If you really need the accuracy, could you not multiply by
10e22 before rounding? Sorry if this is simplistic, but without knowing
what you're trying to do, it's hard to envision a need for that kind of
accuracy.
tc
Ferencz wrote:
Hi tc
Thx but that is is wrong the formula works fine in Excel, no problem.
Ferencz
----- Original Message ----- From: "Anthony Chilco"
<[EMAIL PROTECTED]>
To: <[email protected]>; <[EMAIL PROTECTED]>
Sent: 12 February, 2007 17:24
Subject: Re: [users] Excel formula
Hi Ferencz,
I pasted your formula in a spreadsheet, added some values in the
referenced cells and it works fine. I get Err:502 if I2 is greater
than 20.
tc
tc
You appear not to be subscribed to the users' mailing list. You
could miss many of the replies to your post unless you do subscribe.
Just send a blank message addressed to
<[EMAIL PROTECTED]> using the e-mail account through
which you want to receive it. You will receive a message asking you
to confirm your subscription by replying to it. See
http://support.openoffice.org/index.html for more options.
Subscribing is optional. Be aware that after subscribing, you may
receive many messages from the list. Be prepared to set up mail
filters in your email client in order to deal with them.
Ferencz wrote:
Thx
I have replaced the "," with ";" but still no result (get Err:502)
Ferencz
----- Original Message ----- From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: "Ferencz" <[EMAIL PROTECTED]>
Sent: 10 February, 2007 23:02
Subject: Re: [users] Excel formula
Comment in-line
On Saturday February 10 2007 12:27 pm, Joe Conner wrote:
Calc uses semicolons, not commas to separate parameters. I do not
understand what the formula does for you, but I do know that the
ROUND format should be ROUND( NUMBER ; DECIMAL PLACES )
SUM format should be SUM(BEGINNING CELL:ENDING CELL) which does not
seem to be what you want. You seem to want to multiply cell H5 with
I3 then add H5 to that product. If so, that would simply be
(H5*$I$3 +H5).
Ferencz wrote:
> Openoffice ver 2.1
> xp pro
>
> I have an excel formula =ROUND(SUM(H5*$I$3+H5),$I$2) which
> openoffice calc can't intrepert can someone help
>
> Thx
-------------------------------------------------------------------
-- To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
