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?
Appreciate any help in trying to correct this.
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 (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.
› [Solved] How do I not show formula results when cells are blank?
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!!!