Assigning Points based on Late Time
It is shown in this lesson how to utilize the IF function in Excel to allocate points based on the amount of time that has passed. If you intend to pursue along this guide, you may do so by downloading the template spreadsheet. Generic formula: =IF(C2<VALUE(“0:2”),0,IF(C2<VALUE(“0:35”),1,IF(C2<VALUE(“0:45”),2,IF(C2<VALUE(“1:00”),3,IF(C2<VALUE(“3:00”),4,5))))) Return value This formula provides the number of points… read more »