Forum Discussion
Neoma1304
Jan 18, 2024Copper Contributor
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...
- Jan 18, 2024
=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.
OliverScheurich
Jan 18, 2024Gold Contributor
=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.
Neoma1304
Jan 18, 2024Copper Contributor
OliverScheurich THANK YOU!!! I used the first formula and it worked! You've saved me hours of frustration