Search results

I have an addition to this formula I would like to make, I would like the formula to not only read the next stage but once the stage/phase is not completed I would like the formula to pick it up. I have attached the worked of what i am trying to attempt. Thank you for any assistance that you...

Thank you, it was most helpful

I am seeking assistance with a formula, I am trying to show the status of the scope of a project. Please see attached my workbook. I would like the formula to search the status scope column and once there is a status scope open(requested) despite other status being approved or rejected, the...

Thank you, it worked. Regards

I am basically saying once one phase is completed I would like the phase to reflect the next one.

Yes I will, Please see attached a sample of my workbook. Thanks for any assistance that you can give.

I am trying to create a template and i would like help on a formula, I would like a formula to choose the phase a project, so if the initiation phase is complete the formula should show that its in the next phase for example planning, and if both are completed it should show the next phase as so...

Thanks, but i wanted the scores to reflect as % of the cost. I used this to find the score: (Cost/MAX($C$5:$C$8))*100. which resulted in the obvious of the largest cost having the largest score. Qant a formula to inverted that.

I am trying to assign scores to a project, but i want it to be done automnatically based on the cost, however the issue is I want the largest cost to be assigned the lowest score. Can anyone assist me with a formula. Thank you

Thank you both.

Thank you, is there a formula i could use instead of a VBA

I am attemting to create an excel database and would like the last entry to be time stamped. Example if I updated the database yesterday, when i open it this morning I should be able to know it was last updated yesterday. Thank you for your assistance.

I would like a formula that if say A1=1 you cant type in B1 and C1. As well as if B1=1 then A1 and C1 you cant type in and if C1=1 then A1 and B1 you cant type in. Something like mutually exclusive.

Thank you, it worked just fine.

I would like a formulae that would return the text associated with a maxiumum value in a table.

I want a formula that will help me choose between these three (3) options: 1. If greater than 100% then "Targets surpassed" 2. If equal to 100% then "x% of Targets achieved" 3. If less than 100% then "Missed targets by x%"

Thanks Hui

How would i write a formula to show percentage of target achieved for say and expense to income kpi, if my target is greater than my actual. Example: Ratio of expense to income target is 0.69 and the actual for the month is 0.57, what is the percentage of target achieved?

Thank you Luke, your response was great.

I have completed the formula and it is functional, however I was wondering if anyone know a shorter way it could be written using some other function/formulas. Here is the formula...

Yes thank you

I am trying to write a formula, which would involve choosing between a range and then return the corresponding scores. Here is what i did: If(AND(G1="Direct",2500>=G2>=50000),1,""). But it is not working. Kindly assist

Thanks Luke I did that

How to chart data from two different periods to show a comparison. For example I want to show the comparison between May - November 2010 & May - November 2011