How Do I Keep This Cell Blank Until Data is Entered?

[CLRExcel]

Here is the formula I am using in H2.
=IF(COUNTIF(H3:H10,"F"),"Fail","Pass")

What I want to be able to do is have H2 show blank (right now it is showing Pass) until all the cells in the range (H3:H10) have a P, F, or NA entered. Is that possible?

2014-09-24_21-22-51.png

Thanks in advance!

[azumi]

Maybe:

=IF(COUNTIF(H3:H10,"<>"&"?*"),"","Pass")

[sktneer]

Try this.....

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[CLRExcel]

Found one that worked. Thank you! I used =IF(COUNTIF(H3:H10,"<>"&"?*"),"",IF(COUNTIF(H3:H10,"F"),"Fail","Pass")). Much appreciated!

[wesrow]

How would this work with simple math for example =SUM(A2-A1) I want the solution to show in B2 but i want B2 to stay blank until both numbers are installed

[sktneer]

Hi wesrow,
Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.