Here is what I am trying to figure out based on the following: =IF(E>1,YEAR(E14),0) So if a cell shows a date such as 7/2/08 it will show ‘2008’ and if a cell shows text such as ‘mm’ I want it to show zero. Problem is, it will not display a zero for the latter, I assume becaause text is not a calcualtion. how best can I get this to show what I want? thanks
try putting the 0 in quotes… =IF(E>1,YEAR(E14),“0”) …might work?
=if(istext(e14),0,year(e14))
gracias