View Single Post
 
Old 09-01-2016, 08:10 AM
paulkaye paulkaye is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

Thank you.
I edited the formula to keep zero as zero:
=IF(A1=0,0,IF(MOD(A1,1)<=0.4,INT(A1)+1,IF((MOD(A1, 1)>0.4)*(m od(A1,1)<=0.9),INT(A1)+2,"")))
I've "stored" it in cell B1. Unfortunately I'm getting strange results when I copy-paste it into other cells. Some work, and some do not! I copied the formula into cells to the right of the cells containing the original values. Here is the result:

6.7 #NAME?
6.6 #NAME?
4.1 5
5.2 6
0 0
0 0
9 10
6.9 #NAME?
10.7 #NAME?
6.7 #NAME?
9.4 10
4.2 5
0 0
0 0
7 8
0 0
2.5 #NAME?
14.5 #NAME?
1.7 #NAME?
0 0
7.8 #NAME?
8.2 9
6.6 #NAME?
0 0
0 0
0 0
0 0
9.7 #NAME?
3.2 4
4.6 #NAME?
9.8 #NAME?


Any ideas?!

Last edited by paulkaye; 09-01-2016 at 08:12 AM. Reason: pasted values came out distorted
Reply With Quote