Can you tell me what is wrong with this IF(C4:C99="OPEN")and(COUN.

  • Thread starter Thread starter Guest
  • Start date Start date
The answer really is that in Excel the 'and' isn't done like that.

You need to put IF ( AND(test1,test2,test3...),trueans,falseans)
Ian
 
Back
Top