Thread: what does the +1 do in =INT(6*A2)+1?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Hudson Ken Hudson is offline
external usenet poster
  
Posts: 186
Default 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 With QuoteReply With Quote