Prev: Workbook_Open code help
Next: percentage in excel
From: is on 4 Apr 2010 20:21
I have a simple formula which evaluates to 4.3. If I copy the formula and
paste as value, the value I get is "4.29999999999995".

For example:
Finding the difference of 999(A1) and 994.7(B1) with "=B1-A1" the value
returned is 4.3. Put if you copy the formula and paste special as value only
you get the 4.2999 number.

Noticed this when breaking links in a document and it is now driving me crazy.

From: Paul on 4 Apr 2010 20:50

It's not so much a "paste value error" as "the way Excel does math".
The following site provides some information on why this occurs:

'Rounding And Precision In Excel'
(http://www.cpearson.com/excel/rounding.htm)





i
s
@
b
e
r
n
u
l
i
.
c
o
m
;
6
9
0
1
3
4

W
r
o
t
e
:


>
I have a simple formula which evaluates to 4.3. If I copy the formula
and
> paste as value, the value I get is "4.29999999999995".
>
> For example:
> Finding the difference of 999(A1) and 994.7(B1) with "=B1-A1" the
value
> returned is 4.3. Put if you copy the formula and paste special as value
only
> you get the 4.2999 number.
>
> Noticed this when breaking links in a document and it is now driving me
crazy.


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192877

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Workbook_Open code help
Next: percentage in excel