Forum Discussion

Angela McGhin's avatar
Angela McGhin
Brass Contributor
Jul 06, 2018

IF function with multiple logic tests

Hi - I currently have the following formula which works fine:   =IF(SUMIFS(Holidays[[Hours/Day]:[Hours/Day]],Holidays[[Resource Name]:[Resource Name]],Report!$B22,Holidays[[Start Date]:[Start Date]...
excel
Formulas and Functions
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jul 06, 2018

Hey Angela-

 

Hope you're doing well today.  Would you happen to have a small non-sensitive example file that you could provide the community in order to test their solutions on?  Sometimes it's just a little easier to make the adjustments in an actual file rather than toying around with it in your head.  If you could just provide 5 or 6 rows of data with the result now and then the result that you expect with your new formula that would be helpful as well (basically a before and after).  Thanks for posting!

  • Angela McGhin's avatar
    Angela McGhin
    Brass Contributor
    Jul 10, 2018

    Hi Matt

     

    Thanks for your reply - apologies for the delay getting back to you.

    Here's a sample file for you to look at. As you'll see there is:

     - a tab for Business Travel data

     - a tab for Holiday data

     - a tab showing the results (a month to view at a time, month controlled at the top of the sheet)

     

    The dates and days of the week change according to the month selected.

     

    Let me know if you have any questions!!