We use MS Project for work. I want to create a column that multiplies the cost of 'work' resources by 5% and 'cost' resources by 15% for each task line.
In Excel I know I could use an 'ifs' statement (If it is 'work' than x 1.05, if it is 'cost' then x 1.15, if it is neither then do nothing)
= ifs(A2="work", B2*1.05,A2="cost", B2*1.15,"")
I cannot figure out what I need to do in MS project. How do I create a calculation based on the type of resource - Do I need to make multiple columns and then sum them? or can I create a statement formula?
this is the formula I am trying, but of course I am getting errors IIf([Resource Type]="Work",[Cost]*1.05,IIf([Resource Type]="Cost",[Cost]*1.15))