if formula ignoring blank cells

[stephen.smith]

Hey guys I am trying to perform an if formula on a cell which will be either blank or have a value depending on different inputs in a different worksheet. =IF(AP3>AP$51,"SIGNS OF FATIGUE","OK") This is the formula I have tried however i get a #DIV/0! when i perform it. Is there a way to ignore AP3 if this cell is blank.

 

[VoG]

Try

=IF(AP3="","",IF(AP3>AP$51,"SIGNS OF FATIGUE","OK"))