Hi,


can any please advise of the syntax I need to amend the following formula (which is in cell 'T2')

=IF(ISNA(A4),"",IF(AND(S4="Not Due",$F$1-K4>0),"Missed",S4))


to check if cell 'K2' is empty, and if so display 'T2' as blank rather than have 'T2' as #VALUE!


Many thanks in advance

Regards


Rob