Forum Discussion

mkissel1's avatar
mkissel1
Copper Contributor
Jan 07, 2023
Solved

How to associate a word with 0 hours

I am trying to make a work schedule. I am not good with Excel. I am using an excel sheet that allows me to calculate the total hours worked for each person for that week. The only issue I am having i...
excel
Excel on Mac
Formulas and Functions
  • Rodrigo_'s avatar
    Rodrigo_
    Jan 07, 2023

    Hi mkissel1 ,

    use IF and COUNTIF function to translate "OFF" to zero (0)
    =IF(COUNTIF($C4:$M4,"OFF")>=0,0,"insert your formula here")

Peyman_gholami's avatar
Peyman_gholami
Copper Contributor
Jan 07, 2023
Hi @mkissel
If your problem is just the word "OFF", You can use this formula:
=IF(ISNONTEXT(A2:I2)=TRUE,"insert your formula here">

Resources