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

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

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

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

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

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

=IF(OR(A2="",ISTEXT(A2)),"",IF(A2=326,"Pass","Fai l"))

Vaya con Dios,
Chuck, CABGx3




"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

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

Thanks Danny, just what I wanted

Cheryl

"Danny Lewis" wrote:

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