Solved PASS or FAIL Formula

May 13, 2013 at 09:20:15
Specs: Windows 7
I have a gradebook with cell S7 that calculates PASS or FAIL based on the following: =IF(AND(M8>1, R8="Y", Q8>79),"PASS", "FAIL").

The formula is functioning properly; however, I want cell S7 to remain blank until several other inputs are entered. Currently, the cell returns FAIL until I enter data into the other cells.

How do I precede the above statement to remain blank until cell L7 and P7 have numeric entries in them?

This is what I was trying to use: =IF(AND(ISNUMBER(L7), ISNUMBER(P7),” “),IF(AND(M7>1, R7="Y", Q7>79),"PASS", "FAIL")

Appreciate any help in trying to correct this.

See More: PASS or FAIL Formula

May 13, 2013 at 09:28:43
✔ Best Answer
COUNTA will count how many cells in a range contain data. Don't let your formula evaluate the IF function until all 3 cells contain data:

=IF(COUNTA(M8,R8,Q8)=3,IF(AND(M8>1, R8="Y", Q8>79),"PASS", "FAIL"),"")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 13, 2013 at 09:37:54
Thanks. This resulted in "TRUE" in cell S8 vs. "PASS" or "FAIL". Currently cell S8 is formatted as General. What do I need to change to get a response of "PASS" or "FAIL"?

Report •

May 13, 2013 at 11:56:28
Did you copy the formula directly from my post into Excel? It works fine for me.

If any one or more of the cells are empty, I get a blank cell.

If any one or more of the arguments inside the AND are FALSE, I get FAIL.

If all three arguments are TRUE, I get PASS.

Please post the conditions you are using in M8, R8 and Q8 when the formula returns TRUE. Frankly, I don't see any way for that formula to return TRUE. An IF statement only returns TRUE (or FALSE) when a value_if_true (or value_if_false) is not provided for the IF.

Since both IF's have their own value_if_true and value_if_false provided, it should not be returning TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

May 13, 2013 at 13:52:19

I did copy the formula directly. Seems to be some quirk with my spreadsheet. I resaved my file using a different file name and re-cut and pasted the information and it works now. Thank you very much for your expertise and prompt assistance!!!


Report •

Ask Question