Hi, I have the following formula: =IF(OR(E99="No",I99<=4,E99="text",I99="text"),1,0). The objective is to only bring back cells that have No in column E OR <=4 in column I. The problem is there are blank rows. How do I not include the blank cells?
Thank you in advance!
Thank you in advance!