I need to write following Excel formulas in MS Project. Could you please help?

Dezom

New Member
Joined
Jul 21, 2020
Messages
21
Office Version
  1. 2016
Platform
  1. Windows
  2. Mobile
Hello Everyone,

I need help from you to write formulas in MS project. I had a file in Excel. But I need to use MS Project because of management decision. MS Project formula language is different and I do not have any experience about it before. I will be really glad if you can help me about it. In the table I have made the columns yellow which has following formulas.

Those three formula I need to write;

Formula1:

IF(OR(E2="Adjustment";E2="Secondary Work";E2="Technical Secondary Work";E2="Production";E2="Engineering Control Work");WORKDAY.INTL(H2;2;1);IF(OR(E2="Quality Control Work";E2="Assemble");WORKDAY.INTL(H2;1;1);IF(AND(E2="Primary Assemble";M2>G2;M2<N2);N2;EĞER(VE(E2="Primary Assemble";G2<MIN(M2;N2));MIN(M2;N2);IF(AND(E2="Primary Assemble";G2>MAK(M2;N2));WORKDAY.INTL(H2;2;1);"cant be calculated")))))

Formula 2:
IF(AND(H2>=DATE(2020;1;1);H2<=DATE(2020;1;4));"W1";IF(AND(H2>=TARİH(2020;1;6);H2<=DATE(2020;1;11));"W2";"continue")

Formula 3:
IF(ISNUMBER(SEARCH("Adjust";D3));"Adjustment";IF(ISNUMER(SEARCH(" TN ";D3));"Technical Secondary Work";IF(ISNUMBER(SEARCH("Production";D3));"Production")))


Paylaşım Prototip.xlsx
ABCDEFGHIJKLMN
1EmployeeWeekTaskTask DescriptionTask TypeDurationDate for assigning the taskPlanned Task TerminStatu of TaskReal Finish DateTime PeriodFinal TerminCalendar Termin based on Time PeriodTermin based on Vehicles
2Johnwill continue1224Primary Assemble F40-9999 Illustration EditionPrimary Assemble1423.7.208.8.20OK6.8.2030 TP28.8.201.9.2028.8.20
3Jonathanwill continue1564Primary Assemble BVN003 F41-9888 Electrical CablingSecondary Work2223.7.2029.7.20OK7.8.2028 TP31.7.2017.8.2017.7.20
4Harry will continue1767Primary Assemble Quality Control Work F39-5555 Lighting EditionQuality Control Work523.7.2024.7.20OK25.7.2026 TP27.7.202.7.2016.7.20
5Hanswill continue2334Primary Assemble Adjustment F41-9888 Electrical CablingAdjustment923.7.2021.8.20Working30 TP25.8.201.9.2028.8.20
6Alicewill continue7886Primary Assemble Production F88-3579 Heating workProduction423.7.2027.7.20OK28.7.2021 TP29.7.208.6.20
7Marrywill continue5331Primary Assemble 30C-8456 creating a new groupPrimary Assemble2023.7.2014.9.20Waiting33 TP18.9.2016.9.2018.9.20
8Karhanwill continue1005Primary Assemble 30C-6578 creating a new groupPrimary Assemble3223.7.2014.9.20Waiting33 TP18.9.2016.9.2018.9.20
9Sitovicwill continue9564Primary Assemble TN 30C-1234 Controlling a new groupTechnical Secondary Work823.7.2014.9.20Waiting33 TP16.9.2016.9.2018.9.20
10Boriswill continueChecklistF40-9999 Checklist Primary AssembleChecklist2020.8.2029.8.20Workingcant be calculated
11
12
13
14
15
16Formulas
17Final Termin (L2)
18Week (B2)
19Task Type (E2)
Prototype
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,491
Messages
5,764,681
Members
425,229
Latest member
Rashid mahmood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top