Tags:
Thanks! We'll email you
when relevant content is
added and updated.
Following
Follow
Excel 2003
Thanks! We'll email you
when relevant content is
added and updated.
Following
Follow
Excel functions
Thanks! We'll email you
when relevant content is
added and updated.
Following
Follow
Microsoft Excel
I used the "trunc" function this way "=TRUNC((H41-(I41*25))/10,9)", where H41is "=(A41-INT(A41))*100" and I41 is "=TRUNC(H41/25)". A41 is 346.95.
With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2.
What am I doing wrong? Or is there a fault with Excel?
Software/Hardware used:
Microsoft Excel 2003
ASKED:
February 16, 2010 2:30 AM
UPDATED:
April 5, 2010 3:16 PM
Discuss This Question: 13 Replies