I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

=IF(AND(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS")),D28),"yes","no")

Not sure if this is what you need. If not post back with clearer detail on
the criteria you want to test.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


" wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

On 4 Apr 2007 08:47:15 -0700, wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,


=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),D2=8),"yes","no")

I don't know what you mean by "D2 (date created) is greater then 8 days", so
you'll have to alter that in 5h3 rund5ion.


--ron

On Apr 4, 11:57 am, Ron Rosenfeld wrote:
On 4 Apr 2007 08:47:15 -0700, wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),D2=8),"yes","no")

I don't know what you mean by "D2 (date created) is greater then 8 days", so
you'll have to alter that in 5h3 rund5ion.

--ron

What I mean by D2 cell (date created) is greater than 8 days is: If
the order was created on April 1 and it is now 8 days later (April 9)
then populate yes.

On 4 Apr 2007 11:40:20 -0700, wrote:

On Apr 4, 11:57 am, Ron Rosenfeld wrote:
On 4 Apr 2007 08:47:15 -0700, wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),D2=8),"yes","no")

I don't know what you mean by "D2 (date created) is greater then 8 days", so
you'll have to alter that in 5h3 rund5ion.

--ron

What I mean by D2 cell (date created) is greater than 8 days is: If
the order was created on April 1 and it is now 8 days later (April 9)
then populate yes.


Then that portion of the formula should read
...,(TODAY()-D2)=8),...
--ron

On Apr 4, 3:36 pm, Ron Rosenfeld wrote:
On 4 Apr 2007 11:40:20 -0700, wrote:





On Apr 4, 11:57 am, Ron Rosenfeld wrote:
On 4 Apr 2007 08:47:15 -0700, wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),D2=8),"yes","no")

I don't know what you mean by "D2 (date created) is greater then 8 days", so
you'll have to alter that in 5h3 rund5ion.

--ron

What I mean by D2 cell (date created) is greater than 8 days is: If
the order was created on April 1 and it is now 8 days later (April 9)
then populate yes.

Then that portion of the formula should read
...,(TODAY()-D2)=8),...
--ron- Hide quoted text -

- Show quoted text -

Ron,

Thanks for your help but can you write this out in full for me. I
have tried adding the above to the formula and it doesn't seem to work.

On 4 Apr 2007 13:27:38 -0700, wrote:

On Apr 4, 3:36 pm, Ron Rosenfeld wrote:
On 4 Apr 2007 11:40:20 -0700, wrote:





On Apr 4, 11:57 am, Ron Rosenfeld wrote:
On 4 Apr 2007 08:47:15 -0700, wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,

=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),D2=8),"yes","no")

I don't know what you mean by "D2 (date created) is greater then 8 days", so
you'll have to alter that in 5h3 rund5ion.

--ron

What I mean by D2 cell (date created) is greater than 8 days is: If
the order was created on April 1 and it is now 8 days later (April 9)
then populate yes.

Then that portion of the formula should read
...,(TODAY()-D2)=8),...
--ron- Hide quoted text -

- Show quoted text -

Ron,

Thanks for your help but can you write this out in full for me. I
have tried adding the above to the formula and it doesn't seem to work.


=IF(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS"),(TODAY()-D2)=8),"yes","no")


--ron