Maybe this will work for you
=IF(A1="OFF","0","")

"HRlady" wrote:

Again, working on putting a employee schedule together. How do I set it up so
that when the word "Off" is inputing into the schedule column the total
column (the one next to it) automatically inputs zero?

Thank you