Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Custom rounding up
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-01-2016, 07:41 AM
xor xor is offline Custom rounding up Windows 10 Custom rounding up Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom rounding up Excel Seems to be Rounding Twice Rather Than Once melissapete24 Excel 5 08-27-2016 12:51 AM
Custom rounding up Time Calc with rounding. billreed7 Excel 5 07-03-2016 06:43 PM
Rounding to nearest 0.25 Guloluseus Excel 5 10-27-2015 11:28 PM
Rounding values inconsistent required_username Excel 10 06-05-2014 05:35 AM
Custom formatting code - rounding problem venkys4u Excel 1 08-14-2012 07:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft