my question is: if I use a true / false function:
H10 =if(G10>$G$1,"Pass","Fail")
H11 =if(G11>$G$1,"Pass","Fail")
However, if G11 is a blank cell, it returns "Pass" on H11, but actually it is a blank cell
How do I tell the function to ignore blank cell (G11) and gives me a return of blank cell (H11)?
Bookmarks