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