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

G

Guest

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
 
G

Guest

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

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Hide columns based on row values 2
Copying formulas across columns 2
Formula than understands midnight? 25
Repeat formula for all cells in whole column 1
activate formula when adjacent cell populated 4
Copy corresponding cell in Column B if cell in A contains certain text? 1
Overwriting a cell with a formula without deleting the formula 1

Top