rounding problems

K

Kim

Why does 2565.48 round to 2566 and 3136.90 round to 3136?
My whole worksheet appears to be inconsistent. How can I set the entire
sheet to round up at .50+ and down at .49-?
 
G

Gary Brown

You should answer Bernard in your first posting of this question and not ask
it twice, wasting our time.
 

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

rounding a number up to a certain ending digit 6
Organizing a group of notebooks 0
ROUNDING 2
Divide a # into 3 #'s rounded to a whole # 9
Round Function 5
Alternate Rounding Up & Down of .50 in a column 5
Excel Currancy Decimals 3
Rounding Time. 7

Top