Simple Formula

K

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.
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top