Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I was looking to get assistance with a formula in Excel 2002
I am creating a if/then formula that will look at a cell in column A that
contains either one of the following day notations MON, TUE, WED, THU, FRI, SAT, SUN, or HOL. If the date is between any non holiday weekday it should be included in a count. The second part of the if/then statement includes the choice between OK and DEFECT. I am trying to count only the defects that happen during non holiday dates for entire month. I have written the following formula for a single day but have had no luck. Can anyone point me in the right direction? =IF((($A7=MON, TUE, WED, THU, FRI)=AND($D7=DEFECT)),1,0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2000 to Excel 2002 problem | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |