I have three formulas that I need to combine but can?t get it to return the correct response.
I have =IF(A1>A2,A2+1-A1,A2-A1) to calculate time worked
Then I want =IF(A1=?text?, value_to_return, ?0?)
Finally I would love to add =IF(A1=?hol?, value_to_return, ?8?)
Any tip?s appreciated
Bookmarks