Help.
I previously used IF And Function to return a resource value depending on the date and where it fell in the time period of a project (based on dates). I would like to add a further argument so that the result is also dependent on the job role (as this varies for job role and time period.) Is it possible to add another argument?
IF AND, AND?
=IF(AND(J$5>=$C6,J$5<$D6),$E$22,IF(AND(J$5>=$D6,J$5<$E6),$E$23,IF(AND(J$5>=$E6,J$5<$F6),$E$24,IF(AND(J$5>=$F6,J$5<$G6),$E$25,0))))
Start Up (FPI - 8wks) FPI LPFV LPLV DBL Role Oct-16 Nov-16 Dec-16 Jan-17
PRIMA 08-Jun-16 03-Aug-16 18-Aug-18 01-Oct-21 01-Dec-21 DM 0.02 0.02 0.02 0.02
DM CTM SCTM
Start Up Period FTE/Site 0.05 1 0.4
Enrollment Period FTE/Site 1.00 1 1
Maintenance Period FTE/Site 1 1 1
DBL to Close Out Period FTE/Site 0.05 1 0.4
I previously used IF And Function to return a resource value depending on the date and where it fell in the time period of a project (based on dates). I would like to add a further argument so that the result is also dependent on the job role (as this varies for job role and time period.) Is it possible to add another argument?
IF AND, AND?
=IF(AND(J$5>=$C6,J$5<$D6),$E$22,IF(AND(J$5>=$D6,J$5<$E6),$E$23,IF(AND(J$5>=$E6,J$5<$F6),$E$24,IF(AND(J$5>=$F6,J$5<$G6),$E$25,0))))
Start Up (FPI - 8wks) FPI LPFV LPLV DBL Role Oct-16 Nov-16 Dec-16 Jan-17
PRIMA 08-Jun-16 03-Aug-16 18-Aug-18 01-Oct-21 01-Dec-21 DM 0.02 0.02 0.02 0.02
DM CTM SCTM
Start Up Period FTE/Site 0.05 1 0.4
Enrollment Period FTE/Site 1.00 1 1
Maintenance Period FTE/Site 1 1 1
DBL to Close Out Period FTE/Site 0.05 1 0.4