Thread: Custom rounding up
View Single Post
 
Old 09-01-2016, 07:41 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
=if(mod(a1,1)<=0.4,int(a1)+1,if((mod(a1,1)>0.4)*(m od(a1,1)<=0.9),int(a1)+2,""))
Reply With Quote