Thread: number rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default number rounding
Use the ROUND() function:

=ROUND(A1,0)

will yield 1 if A1 contains 1.1
will yield 2 if A1 contains 1.9
--
Gary's Student


"tamiluchi" wrote:

can i set rounding conditionally? up from .5, down if below?
Reply With QuoteReply With Quote