Two If's - one in a range
Put this in C8...........
=IF(AND(COUNTIF(F36:F45,"ACS")0,E18="yes"),"Yes", "")
Vaya con Dios,
Chuck, CABGx3
"Shelly" wrote:
I'm trying to do the following:
If E18=Yes
and If any cell F36 through F45 = ACS
Then
c8=Yes
and C9 = Yes
I've tried several things, but cannot get it to work.
Thanks!
|