round up

[firroo]

Hi all,

I am doing the prices for my products and I end with numbers like 123 or 449
is there a way where we can round the lat digit in the right to be either
zero or 5 which is nearer like 123 to become 125 & 449 to become 450.

Thanks

 

[Mike H]

Maybe

=ROUND(A1/5,0)*5

Mike

 

[firroo]

Thank you Mike it works very well.

Regards

Maybe

=ROUND(A1/5,0)*5

Mike