What does this formula mean?

=IF(DATEDIF(K4,"12/31/2004","m")=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

Hi

This looks at the difference in months between K4 and 31st December 04 and
if it is more than or equal to 20, or less than 8 it will put a zero in the
cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" wrote in message
...
What does this formula mean?

=IF(DATEDIF(K4,"12/31/2004","m")=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

and it can be simplified to

=IF(AND(DATEDIF(K4,"12/31/2004","m")=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy wrote in message ...
Hi

This looks at the difference in months between K4 and 31st December 04 and
if it is more than or equal to 20, or less than 8 it will put a zero in
the
cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" wrote in message
...
What does this formula mean?


=IF(DATEDIF(K4,"12/31/2004","m")=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))

Bob

I think you mean:
=IF(OR(DATEDIF(K4,"12/31/2004","m")=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4/12))

Andy.


"Bob Phillips" wrote in message
...
and it can be simplified to

=IF(AND(DATEDIF(K4,"12/31/2004","m")=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy wrote in message ...
Hi

This looks at the difference in months between K4 and 31st December 04
and
if it is more than or equal to 20, or less than 8 it will put a zero in
the
cell. If it is neither of these (ie between 9 and 19) if will put in
Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" wrote in message
...
What does this formula mean?


=IF(DATEDIF(K4,"12/31/2004","m")=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))

Indeed I did Andy. Thanks

Bob


<Andy wrote in message ...
Bob

I think you mean:

=IF(OR(DATEDIF(K4,"12/31/2004","m")=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4
/12))

Andy.


"Bob Phillips" wrote in message
...
and it can be simplified to


=IF(AND(DATEDIF(K4,"12/31/2004","m")=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy wrote in message ...
Hi

This looks at the difference in months between K4 and 31st December 04
and
if it is more than or equal to 20, or less than 8 it will put a zero in
the
cell. If it is neither of these (ie between 9 and 19) if will put in
Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" wrote in message
...
What does this formula mean?



=IF(DATEDIF(K4,"12/31/2004","m")=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))