Thread: round up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
firroo firroo is offline
external usenet poster
 
Posts: 15
Default round up

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