Simple Formula

[Kat3n]

I have a formula, bt4/37 (bt4 = 6) and it returns 5. However, my calculator
and an Access database returns 16. Can someone tell me why Excel returns 5?
thanks.

 

[Mike H]

hi,

Either I'm reading this post incorrectly or you have a broken calculator and
are gettting results out of excel & access that are equally incorrect.

6/37= 0.162 recurring

So if we assume that your result of 16 is a typo and you meant .16 there
must be something your not telling us about the formula your using in Excel.


How is the 6 derived in BT4 ?
What is the format of BT4 ?
Post the precise formula that gives an answer of 5
What is the format the cell that has this formula in?


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.