I need a formula to combine the following
1 Person completes same day = $15
2 people completes same day = $7.5
3 people completes same day = $5
4 people completes same day = $3.75
1 person completes two day = $10
2 people completes two days = $5
3 people completes two days = $3.3
4 people completes two days =$2.50
If the end date from C4:C7 is greater than 1 day from B4:B7 then it is 0
Solved by T. S. in 28 mins