How do I round last number without a decimal point

G

Guest

I want to round a number, either up or down depending on the last digit. I
tried to use "roundup" and "Rounddown" but those are for numbers with a
decimal place, my database does not have decimals. I want to change numbers
like; 4507, and 4503, to 4510 and 4500 (respectively) . I also tried
"=($D4(last_digit>5,"rounddown",roundup) but there is no "last_digit"
command, so obviosly is cant work!!

Any suggestions?

Thank you in advance
 
J

JE McGimpsey

use a negative argument for decimal places (from Help: "If num_digits is
less than 0, then number is rounded to the left of the decimal point."):

=ROUND(A1,-1)
 

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 numbers, with-out decimals. IE:4507 to 4510 3
round up 1
excel 2003 zero as last decimal 5
Round a repeating decimal from a formula... 14
how do i round a quotient to specific decimal places? 3
Excel 2007 adding a column of negative and positive number 2
How to stop Excel from rounding a number? 3
A non roundup decimal place cell format 6

Top