Thread: Rounding up @ 3 instead of 5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Rounding up @ 3 instead of 5
=INT(A1)+(MOD(A1,1)=0.3)


"keith" wrote:

Cant figure out formula to round up if greater than ##.3 instead of ##.5
Please help.

Thanks



Reply With QuoteReply With Quote