($A$1:$A$7={"aa","bb","cc"})


--


Regards,


Peo Sjoblom


"pierre" wrote in message
...
please one more little thing :(related to my precedent issue)
how to resolve this equation in a shorter way ??
if(($A$1:$A$7="aa")+($A$1:$A$7="bb")+($A$1:$A$7="c c")

THANK YOU