Hi Cheryl

=IF(A2="","",IF(A2=326,"Pass","Fail"))

Danny

"Cheryl" wrote:

I have column A which has a score in it . In column B I have the formula:

=IF(A2=326,"Pass","Fail")

This works ok but enters Fail even if there is no entry in column A. I want
to add to the formula the condition that if the cell is blank then the cell
in column B should also be blank.

I would be grateful for any help,

Thanks,

Cheryl