Bug in the Trunc function !?!

When trying to extract the decimal part of a number a really odd thing happens, I will try to explain the simple spreadsheet which displays this odd problem

........A..........B....................C..............D.................E
....................=trunc(A1).......=A1-B1......=C1*10........=trunc(D)
1......22.6......22...................0.6............6..................6
2......22.7......22...................0.7............7..................6............-obviously should be 7 Why would TRUNC(7) = 6
3......22.8......22...................0.8............8..................8
4......22.9......22...................0.9............9..................8............-obviously should be 9

I want to trunc "result D" again in case someone started with a number that included more than the tenths, ie hundreths, thousandths, etc., but it behaves very oddly. If I change the ten multiplier in D to 10.1, the trunc functions correctly. To me this has to be a bug with Excel which is very strange to find in a 2007 product. Has anyone experienced this?

The following reslults are obtained:
0 = 0
.1 & .2 = 1
.3 & .4 = 3
.5 = 5
.6 & .7 = 6
.8 & .9 = 8

To my understanding the INT function always rounds down but the TRUNC function should just remove the fraction portion. Please let me know if there is something about the TRUNC function that I am unaware of.

Why not use:
=MOD(A1,1)

Assuming that the values are on column A starting from A1. If you don't want your result in decimal then you can add this to the formula:
=MOD(A1,1)*10
If all your values in column A only have 1 decimal place, if you have 2 decimal places then times it by 100

I need the number from the tenth place as a single integer so your idea may not work well if a person types in multiple places after the decimal point. I have found a solution to my original formula which is to multiply by 10.1 instead of ten. All number regardless of what a person types in will calculate correctly. I still find the original calculation extremely odd and believe it is an error in Excel programming.

My final formula if you are curious is: trunc((#-trunc(#))*10.1)
I suppose rounding the number in the beginning would add a bit more accuracy to it also.

Thanks for the suggestion as I have never used the MOD function previously.

Anyone else understand if my original question is due to a programming error or an explanable result for the TRUNC function?

I have been playing a bit and found even more oddities: trunc((7.7-trunc(7.7))*10)=7 but ironically trunc((8.7-trunc(8.7))*10)=6

See http://www.excelforum.com/excel-work...ted-input.html

The reason is similar.

Mac, you can mark the thread as Solved yourself.

In the first post in the thread click the Edit button, then click Go Advanced. In the Prefix box, select Solved and then submit the post again.