I think you want something like this:

=IF(COUNTA(J13,L13,N13)=0,"",IF(J13="No","",IF(N13 <=L13,"Yes","No")))

Hope this helps.

Pete

"Adam" wrote in message
...
Hi

I'm using the following formula for my mail monitoring spreadsheet:

=IF(N13<=L13,"Yes",IF(N13L13,"No", IF(J13=No,"")))

Column J is the "Response required?" column
Column L is the "Target Date" column
Column N is the "Actual Response Date" column
Column P is the "On target?" column

There are only 3 entries on my spreadsheet which were all responded to
within target. Therefore there is a "Yes" in column P in all three rows.

HOWEVER, the word "Yes" continues all the way down column P even though,
as
I've said, there are only three entries.

Could anyone advise me how to keep column P blank unless there is an entry
on the row (without losing the formula!)

Sorry for the wordiness of this question.

Regards,
Adam