Thread: Round down if decimal 0.33 or below up if 0.34 or above
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Round down if decimal 0.33 or below up if 0.34 or above
=if(mod(A1,1)<=.33,int(A1),Int(A1)+1)


"tennisnut" wrote:

Is there a formula that allows you to choose where to round up and down from.
EG 1.33 = 1 and 1.34 = 2
Reply With QuoteReply With Quote