Good Afternoon All,
I was kindly provided through this site the below sum.
=IF(OR(ISBLANK(E11),ISBLANK(G11)),"",NETWORKDAYS(E11,G11)-1)
This is working correctly but I need to go a step further and have a sum look at if this is within our SLA so I have the below.
=IF(AND(H11>=0,H11<=5),"Pass","Fail")
The issue that I have is that the blank cells being left by the first formula are creating a “Fail” response. I need this to sum to do the following:
Pass if between 0 and 5
Fail if 6 and over
If no number in the cell (blank) then no response
Your help is greatly appriciated
Bookmarks