Thread: Rounding
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Rounding
=MAX(A1,ROUND(A1,))


"Lime" wrote:

Hello
Can someone Help me.. I'm stuck!!
can you tell me the formula for round up...after .49? if the number is 7.6..
I want to round to 8.

Any help is greatly appreciated...

Lime
Reply With QuoteReply With Quote