By the way, I like the decimals of x/7ths. The same six numbers, always in the same order: 14 28 57. It just starts from different positions, depending on x:
1/7=0.14 28 57 14 28 57... 2/7=0.28 57 14 28 57 14... 3/7=0.4 28 57 14 28 57 1... Besides: Int(14.2857...×2)=28, Int(28.5714...×2)=57 and Int(57.1428.. .×2)-100=14. I know, out of topic, but I like it anyway. Regards Johnny 2006/12/25, Joe Conner <[EMAIL PROTECTED]>:
I believe cell A2 is behaving correctly. If you carry out the division in cell A2 you come up with the number 0.14285714285714 and when you subtract 1.5 from it the result is -1.357142857142860 which when the cell is formatted as a fraction will display -19/14. Likewise, cell A3 is behaving correctly I think. If you carry the actual division out for 2/1/7 you get 0.28571428571429 and 2/2/7 you get 0.14285714285714 now subtract them, and format the cell as a fraction. The cell converts to the fraction 1/7th. The math is correct. It is just user error to understand what is being shown. Garbage in = garbage out. Joe Kirill S. Palagin wrote: > (I am providing example). > > In file at http://www.mytempdir.com/1133344 : > Cell A4 contains properly formatted input, and function returns expected > result. > Cell A3 contains date as parameter, but without quotation marks; > function returns garbage. > Cell A2 contains obvious garbage in input, function still accepts that. > > What do you think of such behavior? > > Thanks. <<SNIP>> > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
