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.
Please check out the attached version.
Hi Hans,
Thank you so much.
This is exactly how i wanted to create this timesheet but as i wrote before, i could never figure this out myself....
I appreciate your quick response and excellent help...
Have a nice weekend.
Greetings Jeroen