Create a function wher last digit is always set

M

mcd_fan

I want to create a funtion where the last digit of a four or five digit
number is alway "9". Any suggestions would be appreciated.

Thank you,
 
M

mcd_fan

CELL A1 is 253
CELL A2 is 18567
CELL A3 is 8932

but I want it to read

CELL A1 259
CELL A2 is 18569
CELL A3 is 8939

I basically want it to round up to 9, The cloestes thin I could find was the
IF function but that would not work the way I want it too.

Thanks,
 
Top