vendredi 23 octobre 2020

How do you write an IF formula to review 4 separate cells and apply separate WORKDAY formulas?

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