Problem with Formula

L

Lee

I have experienced a bug with excel. It doesn't happen
all the time, but it has happened on more than one
occasion.

The problem is when I add cells together, the formula
doesn't come out to the right answer. The following is
an example (shown with 4 decimal places):


Add: 22,112.5200
161,241.7800
15,000.0000

Less: (40,222.0100)
(157,000.0000)
________________________

1,132.2900 - should be the correct
answer, but instead the answer reads:
1,132.289999999995


Thanks
 
P

Paul Corrado

Lee,

Was there something wrong with the answers that were posted to this question
when you asked it yesterday?

PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top