Thread: INT function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default INT function

What does the INT function do in this formula:

=IF(F7<0,"N/A",(INT(MONTH(TODAY())-MONTH(G7))/$L$1)*F7)

So far as I can tell, =MONTH(TODAY())-MONTH(G7), where G7 is 9/22/2006,
yields an integer, namely, 1. Why, then, would INT be in front of it?

Dave
--
Brevity is the soul of wit.