How do I round last number without a decimal point

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)

In article <[email protected]>,
"rollover22" <[email protected]> wrote:

> 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

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

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)

In article <[email protected]>,
"rollover22" <[email protected]> wrote:

> 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