|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.