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