Forum Discussion
Solved
IF, AND and OR
=IF(AND(OR(D21:G21>=6);OR(D20:G20>=6);"OPEN";"CLOSED"), the program claims there's an error in applying D21:G21, either to AND and OR. Am i able not to apply just "D21>=6;E21>=6;F21>=6;G21>=6" and ma...
Francisco_Morassutti , Hi, one way to use a range instead of individual cells in the formula that you are probably intending is to use COUNTIF function
See attachment,
=IF(AND(COUNTIF(D20:G20,">=6")>0,COUNTIF(D21:G21,">=6")>0),"OPEN","CLOSED")
Francisco_Morassutti , Hi, one way to use a range instead of individual cells in the formula that you are probably intending is to use COUNTIF function
See attachment,
=IF(AND(COUNTIF(D20:G20,">=6")>0,COUNTIF(D21:G21,">=6")>0),"OPEN","CLOSED")
amit_bhola, thank you so much, it was exactly what i was looking for.