I was looking to get assistance with a formula in Excel 2002

maybe

=IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D7="Defect"),1, 0)

"cashman" wrote:

> 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)

Thanks, but it didn't work.

"Duke Carey" wrote:

> maybe
>
> =IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D7="Defect"),1, 0)
>
> "cashman" wrote:
>
> > 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)

Works perfectly. Just copy it from the message and paste it into your
spreadsheet

"cashman" wrote:

> Thanks, but it didn't work.
>
> "Duke Carey" wrote:
>
> > maybe
> >
> > =IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D7="Defect"),1, 0)
> >
> > "cashman" wrote:
> >
> > > 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)

It works for me.

I've never seen the curly brackets used that way before. Usually they are
inserted automatically when you do an array formula with ctrl-alt-enter.
Can they be used anywhere you want to use a list of possible values?

--
Carlos

"Duke Carey" <[email protected]> wrote in message
news:[email protected]...
> Works perfectly. Just copy it from the message and paste it into your
> spreadsheet
>
> "cashman" wrote:
>
> > Thanks, but it didn't work.
> >
> > "Duke Carey" wrote:
> >
> > > maybe
> > >
> > > =IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D7="Defect"),1, 0)
> > >
> > > "cashman" wrote:
> > >
> > > > 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)

Carlos -

I'm far from an expert on where & when you can use the curly brackets.
Harlan Grove is the one to whom you should pose your question. He seems to
have an encyclopedic knowledge about their use.

Duke

"CarlosAntenna" wrote:

> It works for me.
>
> I've never seen the curly brackets used that way before. Usually they are
> inserted automatically when you do an array formula with ctrl-alt-enter.
> Can they be used anywhere you want to use a list of possible values?
>
> --
> Carlos
>
> "Duke Carey" <[email protected]> wrote in message
> news:[email protected]...
> > Works perfectly. Just copy it from the message and paste it into your
> > spreadsheet
> >
> > "cashman" wrote:
> >
> > > Thanks, but it didn't work.
> > >
> > > "Duke Carey" wrote:
> > >
> > > > maybe
> > > >
> > > > =IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D7="Defect"),1, 0)
> > > >
> > > > "cashman" wrote:
> > > >
> > > > > 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)
>
>
>