Thread: rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default rounding
=CEILING(A1,50)

On 5 Mar, 10:32, "Andrew Richards" wrote:
Dear All,

How can I round values eg 446,,495 *to nearest zero value eg: 450 or 500

thanks

--
Kind Regards,

Andrew Richards

Reply With QuoteReply With Quote