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_digit5,"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 ,
"rollover22" 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_digit5,"rounddown",roundup) but there is no "last_digit"
command, so obviosly is cant work!!

Any suggestions?

Thank you in advance