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
 

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

Similar Threads

Calculating Annual % Increase that occurs mid month 8
w/s Formula to Automatically Create Two 2-equi-interval Tables ?? 14
VLOOKUP Help!!! 3
HELP HELP with excel formulas 2
Vlookup and Hlookup 3
Counting repeatation 1
Help with a MOD and Rounding statement 1
I am trying to use the IF and SUMIF function on Excel 8

Back
Top