LinkBack URL
About LinkBacks
Thanks for the help rylo.
That works but the problem remains. For some reason, 5.3 + 5.3 = 10.6
If you put 5.4 and 5.2, it's says 11, which is correct. But whenever the only decimals are 3s it goes for the old .6
Thanks for the help rylo.
That works but the problem remains. For some reason, 5.3 + 5.3 = 10.6
If you put 5.4 and 5.2, it's says 11, which is correct. But whenever the only decimals are 3s it goes for the old .6
Hi cricket_stoner,
Try this modified formula:
I think the issue was due to Excel's use of binary math, and that 0.6 / 0.6 does not equal 1 in Excel (it's actually 0.99999999999, which when you take the INT of 0.999999 you get 0 instead of 1).
=SUM(INT(J5:J24))+INT(ROUND(SUM(J5:J24-INT(J5:J24)),1)/0.6)+MOD(ROUND(SUM(J5:J24-INT(J5:J24)),1),0.6)
Last edited by Paul; 01-07-2008 at 02:59 AM.
Two other possibilities which don't need to be "array entered"
=INT(SUMPRODUCT(J5:J24*10-INT(J5:J24)*4)/6)+MOD(SUMPRODUCT(J5:J24*10-INT(J5:J24)*4),6)/10
or, if you don't mind using the Analysis ToolPak add-in function DOLLARFR
=DOLLARFR(SUMPRODUCT(J5:J24*10-INT(J5:J24)*4)/6,6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks