Getting a SUM with a cell when using the IF(OR Statement

[desnyder2001]

I'm using the following statement =IF(OR(C1="SAT",C1="Sun"),"Off","8") however I still want the ability to include that in a Sum.

If the cell is a Sat or Sun the the cell =Off, if its not Sat or Sun then the value should = 8
This is a Calendar with required hours in each day, however on SAT and SUN that position is Off

 

[Scott T]

Re: Please Help - Getting a SUM with a cell when using the IF(OR Statement

You do not need the "" around the 8. Putting a number in quotes turns it into text.

 

[DanteAmor]

Re: Please Help - Getting a SUM with a cell when using the IF(OR Statement

Try this

=IF(OR(C1={"SAT","SUN"}),0,8)