I am trying to calculate a result of test as a Pass, Fail or blank(if no numbers entered in the columns E,F,I,and L). I have tried multiple formulas to check if the result of (M15) =IFERROR((E15-L15-I15)/F15,"0") to see if the value is 5 or greater (PASS), less than 5 (FAIL) or leave blank as no data was entered. I tried this =IF(M15>5,"PASS",IF(M15<5,"FAIL",IF(M15>0,"Pass "))) and several other ways, but the !DIV/0 seems to be the problem. Any ideas??
I even tried =IF(M15>5,"PASS") and the blank Iferror(!DIV/0) return a PASS value
Capture.JPG
Bookmarks