GasDetectCopper ContributorJun 17, 2024Days 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...Show More
dscheikeyBronze ContributorJun 17, 2024GasDetect You can achieve this easily with the XLOOKUP() function:=XLOOKUP(C3,A3:A12,B3:B12,,1) or within a formula =XLOOKUP(300,{200,450,700,950,1200,1450,1700,1950,2200,2450},{0,2,3,4,5,6,7,8,9,10},,1) GasDetect.xlsx10 KB
