View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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!