check data

[john]

i have 3 columns, 2001, 2002, 2003

I need to check if there are number for each year.

if there is data in all three years make it say "all
three years"

if only 1 or 2 have data... make it say "not all 3"

the cells im using are a b c

Please help

 

[Frank Kabel]

Hi
maybe something like
=IF(COUNTA(A1:C1)=3,"all 3", "not all 3")