Create a function wher last digit is always set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I have Excel determine what the last digit is in a series? 2
//sk - Max length of a numeric field. 4
Sorting by last digits in cell 4
Barcode Check Digits 3
Need formula to round number up to always end in X.X9 6
calculate using last four digits of number in cell 3
Validation of UK VAT Number 20
11 digits 3

Back
Top