Thread: Round numbers 1.01 through 1.49 to 1.50
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 Round numbers 1.01 through 1.49 to 1.50
Try this:

=IF(MOD(A1,1)=0,0,IF(AND(MOD(A1,1)0,MOD(A1,1)<0.5 ),0.5,1))+INT(A1)


"Thomas Prescott" wrote:

Round the number range from 1.01 through 1.49 to 1.50; and to round 1.50
through 1.99 to 2.00
Reply With QuoteReply With Quote