View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.