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.

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.

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"?

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(orvalue_if_false) is not provided for the IF.Since both IF's have their own

value_if_trueandvalue_if_falseprovided, it should not be returning TRUE.

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

Hi, 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!!!

Andrew

Ask Your Question

Weekly Poll