INT function

[Guest]

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

 

[Dave O]

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?

 

[Pete_UK]

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

 

[Pete_UK]

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

Pete

 

[Guest]

The INT function isn't really necessary here. If NOW() had been used instead
of TODAY the result would have had a fractional time value in addition to the
serial date number. In that case INT would have stripped the time value,
leaving only the serial date number, but even then it would have been
unnecessary.

 

[Niek Otten]

Even more;

INT(MONTH(TODAY())

returns an integer

So indeed the INT seems superfluous

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[Guest]

Agreed, thanks.
--
Brevity is the soul of wit.

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

 

[Guest]

Hi--$L$1 is 48.0

In any event, it's not included in the INT() function. Take a look at the
formula again.

I've removed it from the formula and get the same result. The only thing I
can think of is that whoever originally made this spreadsheet either had a
use for it in its original form, or, else, didn't understand what INT is
supposed to do.

Dave

 

[Guest]

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

 

[Pete_UK]

Kevin,

I disagree again - MONTH(NOW()) will return 10 for today.

Pete

 

[Guest]

Pete, what I said in the prior post is that the NOW() function would return a
fractional time amount, and of course, if enclosed in an INT the fractional
amount would be excluded from the result. So we're in agreement here.
However, INT is not necessary as MONTH(NOW()) will return an integer
regardless.

MONTH(NOW()) and MONTH(TODAY()) are going to return the same result, with
INT being excess baggage.

 

[Pete_UK]

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 O]

You're correct, I fubarred this one.


Pete_UK wrote:
....

 

[Guest]

Yeah, you're right.