i need to know the purpose of the +1.
M Marcelo Sep 26, 2006 #2 Hi Chantel, it should be to round up eg. if you have 1.34 on A2 it will return 9 because 1.34*6 = 8.04 int(8.04) = 8 8+1=9 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "chantel" escreveu:
Hi Chantel, it should be to round up eg. if you have 1.34 on A2 it will return 9 because 1.34*6 = 8.04 int(8.04) = 8 8+1=9 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "chantel" escreveu:
T Teethless mama Sep 26, 2006 #3 Let's say A2=2.125 A3 =INT(6*A2) The result will be 12. When you add 1, the result will be 13
K Ken Hudson Sep 26, 2006 #4 Hi, Looks to me like it does the same thing as the ROUNDUP function. The INT function returns the integer part of 6*A2 and then 1 is added to it. =ROUNDUP(6*A2) would yield the same result.
Hi, Looks to me like it does the same thing as the ROUNDUP function. The INT function returns the integer part of 6*A2 and then 1 is added to it. =ROUNDUP(6*A2) would yield the same result.
