Round number up to nearest whole 5 or 9

[ChalkyExcel]

I have a sheet with the following numbers:

1012
2037
1083
1080

I would like the numbers above the be rounded up to the nearest 5 or 9. So for the example above the finished result would be:

1015
2039
1085
1079

Any help very much appreciated. Thank you.

 

[AliGW]

I'm not sure what is different about that, it still rounds 1085 to 1089.

Sorry!

=IF(RIGHT(A1,1)="9",A1+1,IF(RIGHT(A1,1)<="4",A1+(5-RIGHT(A1,1)),A1+(9-RIGHT(A1,1))))

 

[Peter_SSs]

Sorry!

=IF(RIGHT(A1,1)="9",A1+1,IF(RIGHT(A1,1)<="4",A1+(5-RIGHT(A1,1)),A1+(9-RIGHT(A1,1))))

Now it changes numbers that already end in 9 to numbers that end in 0.

In any case, I'd go for a formula with just 2 function calls rather than 6.

 

[AliGW]

Now it changes numbers that already end in 9 to numbers that end in 0.

In any case, I'd go for a formula with just 2 function calls rather than 6.

I give up!!!