What does this formula mean?

B

Bucksnut

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

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

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

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