I'm working on a time sheet and I want to create a formula that will check a range of cells for the word "Sick" and add 7 hours for each cell that contains "Sick"
In cell I19 I have the following formula:
=IF(C14="Sick",H19+7,I10-H10)
but I also wants to check cells C15:C18 and add 7 to cell H19 for each of those cells that contains the word "Sick". (so if C14 and C18 both said "Sick", the value in cell I19 would be H19+14) I've tried just creating more IF statements but that doesn't seem to work. Any Ideas? Thanks!
Bookmarks