|
|
#5
09-01-2016, 08:48 AM
|
||||
|
||||
=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 :-)
__________________
Using O365 v2503 - 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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel Seems to be Rounding Twice Rather Than Once
|
melissapete24 | Excel | 5 | 08-27-2016 12:51 AM |
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode