View Single Post
  #1   Report Post  
rollover22
 
Posts: n/a
Default How do I round last number without a decimal point

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