round up
Maybe
=ROUND(A1/5,0)*5
Mike
"firroo" wrote:
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
|