Thread: Custom rounding up
View Single Post
 
Old 09-01-2016, 08:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
=IF(A1=0,0,IF(MOD(A1,1)<=0.4,INT(A1)+1,IF((MOD(A1, 1)>0.4)*(mod(A1,1)<=0.9),INT(A1)+2,"")))

There seems to have been a typo in the mod function you pasted ( m od instead of mod), or the forum gremlins at work :-)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Last edited by Pecoflyer; 09-01-2016 at 09:21 AM. Reason: Corrected after a post by NoSpark
Reply With Quote