The way I see it, F7 multiplies something in brackets, i.e.

(INT(MONTH(TODAY())-MONTH(G7))/$L$1)

and that simplifies to:

INT(something) / $L$1

so the L1 term is outside the INT function.

Pete

Dave F wrote:
Actually, Dave O is on to something. The closed bracket for the L1 term IS
part of the INT() function. Whoever made this function really messed it up!
The odd thing is it's calculating correctly.

Dave
--
Brevity is the soul of wit.


"Pete_UK" wrote:

No, the closed bracket for the INT function is before the L1 term.

Pete

Dave O wrote:
The formula also contains "divide the $L$1", which is also included in
the parens for the INT function. Does L1 contain a value that could
generate a non-integer number?