I need to create one formula which reviews 4 separate cells and determines which WORKDAY formula to apply. How do I nest the multiple IF statements correctly (or use IF(AND) if that is more appropriate?)?
Start:
=IF($C17="ON HOLD","ON HOLD", [all of the remaining formulas should nest here]
If L17 is blank, if Q17 is blank, if $M$13 is “Batch” = WORKDAY(H17,$B$137,$A$95:$B$108)
If L17 is blank, if Q17 is blank, if $M$13 is Not “Batch” = WORKDAY(H17,M17,$A$95:$B$108)
If L17 is blank, if Q17 is Not blank, if $M$13 is “Batch” = WORKDAY(H17,SUM($B$137+Q17),$A$95:$B$108)
If L17 is blank, if Q17 is Not blank, if $M$13 is Not “Batch” = WORKDAY(H17,SUM(M17+Q17),$A$95:$B$108)
If L17 is Not blank, if Q17 is blank, if $M$13 is “Batch” = WORKDAY(L17,$B$137,$A$95:$B$108)
If L17 is Not blank, if Q17 is blank, if $M$13 is Not “Batch” = WORKDAY(L17,M17,$A$95:$B$108)
If L17 is Not blank, if Q17 is Not blank, if $M$13 is “Batch” = WORKDAY(L17,SUM($B$137+Q17),$A$95:$B$108)
If L17 is Not blank, if Q17 is Not blank, if $M$13 is Not “Batch” = WORKDAY(L17,SUM(M17+Q17),$A$95:$B$108)
Aucun commentaire:
Enregistrer un commentaire