Forum Discussion
Combining IF, And, Or and ignoring blanks
Hi, I need some help!! I have managed to combine IF and Or together to do what I need it to do, but I can't seem to get it to ignore blanks. The 'or' options are mainly if a cell is <90, but it in...
=IF(OR(ISBLANK(N2), I2<90, M2<90, K2<90, D2<90), "Yes", "No")
or
=IF(AND(NOT(ISBLANK(N2)), I2<90, M2<90, K2<90, D2<90), "Yes", "No")
or
=IF(AND(NOT(ISBLANK(N2)), I2<90, M2<90, K2<90, D2<90), "Yes", "No")
Rodrigo_ thanks so much for you reply! It is the multiple cells that I need to ignore if blank as N2 is already only counted if it has text in, so it is I2, M2,K2 and D2 I need to only count if they aren't blank - I will try swapping them in and see if it works - fingers crossed!! Thanks again.