Forum Discussion
Solved
Excel formula - Show value in dedicated cell based on various values in multiple cells.
Hi, I would like to get some help with finding a correct formula for the following cases. Case #1 If text in A3 shows 'Monday' i would like to get the autosum of D3-C3 visible at E3. ...
See the attached sample workbook. I used a list of public holidays in The Netherlands; you can edit the list as needed.
In E3:
=IF(A3="Sunday",0,MIN(D3-C3,TIME(8,0,0)))
In F3:
=IF(A3="Sunday",0,D3-C3-E3)
In G3:
=IF(A3="Sunday",D3-C3,0)
Fill down.