Forum Discussion
Days Earned Calculator
Good Day! I have a set of guidelines for earning bonus days off. (eg. between 251-450hrs earns 2 holiday days) As you can see in the attached pic. I would like to build a calculator that wi...
With a slightly different layout of the data it's a simple INDEX and MATCH formula as shown in the sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.