rounded # to correct #

  • Thread starter Thread starter Wagnerk
  • Start date Start date
W

Wagnerk

I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!
 
Hi,

I suspect this is a format issue, format the cell as general
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Suppose I have this:
A1 B1 C1
257 20 12.85 (C1 has =A1/B1)
I cannot see how formatting can give 12.00 - I can see how it could give 13
(with no decimals)
What formula are you using?
best wishes
 
Back
Top