I have a nested IF statement, which runs through checking if there is text in specific cells and returning fail as soon as text is encountered in one of thel celle, otehrwise returning pass if not. Only thing is I have blank rows between each data row and I want to be able to drag the formula down, but have nothing populate where the row is blank. Due to my formula, this keeps returning a pass. The formula I am currently using is a standard if formula - as below:
=IF($A12="CHECK","MANUAL",IF($M12<>"","FAIL",IF($J12<>"","FAIL",IF($F12<>"","FAIL",IF($D12<>"","FAIL","PASS")))))
What do I need to add to this/change to add a condition to ignore the bank rows.
Please see my attachment for further detail.
Thanks
Connie
Bookmarks