What does this formula mean?

[Guest]

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

 

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

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]

Indeed I did Andy. Thanks

Bob

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.