dear expert
Here i need your help i want formula to get result from if condition met criteria in 3 column result success or fail
"IF ZONE IS A AND BOD IS ND THEN TOTAL HOURS IS LESS THAN EQUAL TO 1 I WANT RESULT AS SUCCESS
IF ZONE IS A AND BOD IS ND THEN TOTAL HOURS IS GREATER THAN 1 I WANT RESULT AS FAIL
OTHER THAN A IN ZONE ,B OR ,C OR D THEN TOTAL TOTAL HOURS IS LESS THAN EQUAL TO 2 IS SUCCESS GREATER THEN 2 IS FAIL"
find the attachment
Bookmarks