On 25-10-2009 Colin Hayes wrote:

Try in cell A1

=IF(MOD(B1,12)=1,"year "&1+INT(B1/12),"")

Hi

OK thanks for that

It's working fine where the formula in Column B has returned a number.

Where the formula is not returning a number (and the cell is therefore blank)
, the formula above gives #Value! errors.

Is there a way around this? Effectively the formula in A needs to show blank
where the equivalent cell in B is blank.

Try this one:

=IF(ISNUMBER(B1),IF(MOD(B1,12)=1,"year "&1+INT(B1/12),""),"")

--
Kind regards
Lars Klintholm