Simple If formula but can't get my head around it!

C

Cheryl

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
 
C

CLR

This will also check for TEXT in A2.........

=IF(OR(A2="",ISTEXT(A2)),"",IF(A2>=326,"Pass","Fail"))

Vaya con Dios,
Chuck, CABGx3
 
Top