INT function
Dave,
I agree with your supposition, so in answer to your question - I don't
know.
Have you tried to see what happens if you get rid of it?
Pete
Dave F wrote:
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.
|