Hi All,
I have two sheet in a workbook, 1 sheet named Summary & 2nd Data
In Summary sheet I am taking input from User for country name selection , No of resourses,
& KT duration(In weeks) in cells D6,G6 & J6 respectively.
Now in data sheet cell contains the following values:
K26 : Total Approved Budget
E3 : No of resourses
J3 : Actual total expenses
G3 : KT duration in Days
K3 : Difference between total approved Budget & Actual Expenses.
Now in cell M3 I applied a below formula to calculate by how much weeks we need to extend our KT to utilize the maximum budget ?
=IFERROR(IF(F3<J3,"Project cost is already over budgeted",IF(K3/(J3/G3*7)<1,"Budget is almost fully utilized ","KT duration can be extended by "&TEXT(M8,0))&" more weeks"),"")
I am unable to apply logic how to calculation and unable to find what i am missing in above formula.
Looking for your help how to identify by how many weeks we can extend KT.
Thanks & Regards
Rajender
I have two sheet in a workbook, 1 sheet named Summary & 2nd Data
In Summary sheet I am taking input from User for country name selection , No of resourses,
& KT duration(In weeks) in cells D6,G6 & J6 respectively.
Now in data sheet cell contains the following values:
K26 : Total Approved Budget
E3 : No of resourses
J3 : Actual total expenses
G3 : KT duration in Days
K3 : Difference between total approved Budget & Actual Expenses.
Now in cell M3 I applied a below formula to calculate by how much weeks we need to extend our KT to utilize the maximum budget ?
=IFERROR(IF(F3<J3,"Project cost is already over budgeted",IF(K3/(J3/G3*7)<1,"Budget is almost fully utilized ","KT duration can be extended by "&TEXT(M8,0))&" more weeks"),"")
I am unable to apply logic how to calculation and unable to find what i am missing in above formula.
Looking for your help how to identify by how many weeks we can extend KT.
Thanks & Regards
Rajender