Forum Discussion

Neoma1304's avatar
Neoma1304
Copper Contributor
Jan 18, 2024

Trying to create attendance spreadsheet, stuck on a formula

I am trying to create a workbook to track staff attendance. I've tried a few formulas: IF(OR(B4="Absent","1",""),IF(OR(B4="Tardy","0.33",""),IF(OR(B4="Left Early","0.33",""),IF(OR(B4="FMLA","0","")I...
  • OliverScheurich's avatar
    Jan 18, 2024

    Neoma1304 

    =IF(B4="Absent",1,IF(OR(B4="Tardy",B4="Left Early"),0.33,IF(OR(B4="FMLA",B4="LOA"),0,"")))

     

    =IF(B5="Absent",1,IF(OR(B5="Tardy",B5="Left Early"),0.33,""))

     

    =IF(B6="Absent",1,IF(OR(B6="Tardy",B6="Left Early"),0.33,""))

     

    If these formulas return the intended result it should be possible to add criteria.

Resources