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]
