If Statements

[sharonking66]

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,

 

[Guest]

=IF(AND(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS")),D2>8),"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

 

[Ron Rosenfeld]

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

 

[sharonking66]

=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.

 

[Ron Rosenfeld]

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

 

[sharonking66]

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.

 

[Ron Rosenfeld]

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

 

[sharonking66]

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

--ron- Hide quoted text -

- Show quoted text -

Thank you so much for your help.