Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the +1 do in =INT(6*A2)+1?
i need to know the purpose of the +1.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the +1 do in =INT(6*A2)+1?
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: i need to know the purpose of the +1. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the +1 do in =INT(6*A2)+1?
Let's say A2=2.125
A3 =INT(6*A2) The result will be 12. When you add 1, the result will be 13 "chantel" wrote: i need to know the purpose of the +1. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the +1 do in =INT(6*A2)+1?
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. -- Ken Hudson "chantel" wrote: i need to know the purpose of the +1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|