Thread: I was looking to get assistance with a formula in Excel 2002
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default I was looking to get assistance with a formula in Excel 2002

I don't know what you are trying to do on a bigger picture.. but the
formula would be:

=IF(AND(OR(A7="MON",A7="TUE",A7="WED",A7="THU",A7= "FRI"),D7="DEFECT"),1,0)

There is probably something shorter and easier. but it eludes me right
now

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=563441

Reply With QuoteReply With Quote