Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |