| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statements
On Apr 4, 10:56 pm, Ron Rosenfeld wrote:
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- Hide quoted text - - Show quoted text - Thank you so much for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX, IF statements? | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements | Excel Worksheet Functions | |||
| if statements, I think?? | Excel Discussion (Misc queries) | |||
| IF/AND Statements | Excel Worksheet Functions | |||
Threaded Mode
