I am trying to get this formula to work. I need it to look at three different areas in order to return a yes or no. If I change one area I want it to change the yes or no to correspond with the date for that area. I am using information from a seperate sheet in the same workbook. Here is what I have:
=IF((AND(C13=MILESTONES!$A$6,L13=MILESTONES!$D$1,TODAY()<=MILESTONES!$D$5)),"Yes","No")
Any Ideas???
Hi DJ,
Can't real come up with any ideas without seeing the actual scenario? If you can attach an example that would be helpful.
Regards
Charles
What is the question in this item?
The formula gives you the wrong result?
Otherwise post an example of your excelfile, without confidential information (so we can test the formula).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is sample of the workbook. Sorry I meant to attach it earlier.
And the formula you made is for which cell?
In which cell you want the answer, and what should be the answer for the formula?
I need it to change to Yes Or No depending on the Phase the project is listed as in the Phase Box. The target dates are on the Milestone sheets. If it is past it's target date for that Phase then it will go Red with "No' in the in the Status Box. If it is within the target date for that Phase then it will go Green with a "Yes" in the Status Box.
Thanks for the reply.
I am not as familiar with your sheet as you are.
In which cell (e.g. A4) do you want the result?
OK i think i found it (it shoud be column M)
Should it not be for both (red) cells row 6 (or row 5)?
=IF((AND(C13=MILESTONES!$A$6,L13=MILESTONES!$D$1,TODAY()<=MILESTONES!$D$5)),"Yes","No")
Last edited by oeldere; 07-25-2012 at 04:10 PM. Reason: OK i think i found it (it shoud be column M)
I apologize. What I am trying to do is I have one sheet that shows the status of a project. The other sheet has the project phases and target dates on them. So, on Sheet 1 if the project named "Project X" in A2 is in the Planning Phase in F2 then I need the Status in G2 to show Red "No" if the it is past the target date which I know is TODAY()>="Target Date" or Status in G2 to show Green "Yes" if the it is before the target date which I know is TODAY()<="Target Date". The problem I am having is if I change the Phase in F2 to Implementation then I also need the Status in G2 to change to the corresponding Phase.
I think i get the solution.
See the example.
Notice that I changed the name of the header in Phase 4.
Now you also can change the value in column L.
If you don't fixed it, it get N#A as result, because the value don't match with the data-validation.
Last edited by oeldere; 07-25-2012 at 04:54 PM. Reason: Now you also can change the value in column L.
Re: Need Help with an IF/AND Statement
Thank you. I believe this will work. I will try it when I get to work Tomorrow. You have been a great help.
Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, just ask.
I'm going to ask a goofy question. How do I mark this as solved?
---------- Post added at 08:35 AM ---------- Previous post was at 08:34 AM ----------
Nevermind. I found it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks