=IF(SUMPRODUCT(A2:A5="")0,B1,"")


=IF(OR(A2="",A3="",A4="",A5=""),B1,"")


=IF(COUNTBLANK(A2:A5),B1,"")


the last will not work if the values in A2:A5 are derived from formulas



--


Regards,


Peo Sjoblom

"roger" wrote in message
...
i want to check if any or all the cells a2:a5 are blank
i have tried IF((A2 or A3=""),B1,"") & IF((A2 AND A3=""),B1,"") this
returns NAME
and IF(A2:A5="",B2,"") this is the same as IF(A2="",B2,"") ie just checks
the first cell

the cells i am checking are either blank or x or X.

does anyone have a solution?

regards
Roger