Help!

My formula in Excel 2002 reads: =12.08*85.60 result 1034.048

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  I'm sure this is an easy one, but....  
Author Message
Ro
External


Since: Oct 26, 2005
Posts: 3
PostPosted: Wed Oct 26, 2005 2:06 pm    Post subject: My formula in Excel 2002 reads: =12.08*85.60 result 1034.048
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Does anyone know of a patch, bug, options setting for Excel 2002 that will
correct this?
Back to top
Anne Troy
External


Since: Jun 19, 2005
Posts: 3716
PostPosted: Wed Oct 26, 2005 5:15 pm    Post subject: Re: My formula in Excel 2002 reads: =12.08*85.60 result 1034 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Why is it a bug? Try this one: =0.08*0.6
What do you expect it to return? If you're looking for currency, perhaps you
want:
=round(12.08*85.60,2)
************
Anne Troy
www.OfficeArticles.com

"Ro" <Ro.DeleteThis@discussions.microsoft.com> wrote in message
news:560EA572-C10F-46FF-9E58-C316448DD2CC@microsoft.com...
> Does anyone know of a patch, bug, options setting for Excel 2002 that will
> correct this?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum