Thanks! We'll email you
when relevant content is
added and updated.
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?
Microsoft Excel 2003