View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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.