Forum Discussion
If function in tracking status of my milestones
I really need help in developing an if function syntax on my sheet to track status of milestone dates in my excel sheet. I have 8 milestone which are to be recorded as I achieve those milestone dates. It goes so that every time I put in a certain date I want my status cell to return me the string value I’ve assigned to it. I’m currently using:
If(E20,if(L20,”CC”,”BB”),“AA”)
This is working fine for my first three milestones AA, BB and CC but not going any further than this.
Date values are 7 in my sheet btw, I have to have AA in my default as my 1st milestone as you can understand. If no date values are inserted my first milestone should show AA
10 Replies
Perhaps you may generate small sample file to illustrate the question, without that it's not clear what is needed. That not necessary could be IF() function.
SergeiBaklan The file is attached for your reference. The cell of interest here is D22, where the default cell is required to be "with sales". My milestones are mentioned from F22 to F29. Ideally I'm trying to link D22 cells in my "Order Status" column. Your help is appreciated
Thanks
Thank you for the file, but the logic is still unclear for me. You have list of orders, each of them could have 3 statuses.
But D22 works only with Order #6, shall it be the same for each other order (i.e. same logic in separate column for each order) or you take into account only last order?
What is relationship, if D22 returns Check Received shall B20 be changed on Closed. or in opposite, if Closed we return something in D22?
You have 7 milestones but logic is more or less defined only for 3 of them. When, for example, we shall indicate "Shipment in Transit", when what?
