EXCEL VBA Caluculation ERROR

Thread view:

beersa - 16 Mar 2006 12:29 GMT

I type
?1/3 in excel vba immidiate window
I got the answer 1.323434 instead 1.3333

Can help me why it occurs?

Thks

beersa

Reply to this Message

Gordon Beaton - 16 Mar 2006 12:51 GMT

> I type
> ?1/3 in excel vba immidiate window
> I got the answer 1.323434 instead 1.3333
>
> Can help me why it occurs?

It's truly a mystery, since 1/3 is 0.333333....

/gordon

Signature

[ do not email me copies of your followups ]
g o r d o n + n e w s @ b a l d e r 1 3 . s e

Reply to this Message

Rhino - 16 Mar 2006 16:18 GMT

>I type
> ?1/3 in excel vba immidiate window
> I got the answer 1.323434 instead 1.3333
>
> Can help me why it occurs?

A better place to ask would be a newsgroup that deals with Excel. This is a
programming group for the Java language.

Try microsoft.public.excel.misc. I'm not sure if it is the best of the Excel
newsgroups for this question but they should be able to point you to the
correct newsgroup.

--
Rhino

Reply to this Message

TechBookReport - 16 Mar 2006 17:39 GMT

> I type
> ?1/3 in excel vba immidiate window
[quoted text clipped - 5 lines]
>
> beersa

1. This is a Java newsgroup, not Excel or VBA

2. Doesn't happen here, comes out as 0.3333333

Signature

TechBookReport Java http://www.techbookreport.com/JavaIndex.html

Reply to this Message

EXCEL VBA Caluculation ERROR

Free Magazines