How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24

[Guest]

I'm making a timecard and cannot figure out how to make this formula work
correctly: =IF(C11=TEXT,D11,D11-C11)*24. If I use
=IF(C11="Sick",D11,D11-C11)*24 it works fine, but I have 4 different words I
need to use: Sick, Comp, Vacation, & Holiday. How can I make this work?

 

[Guest]

Try this:

=IF(ISTEXT(C11),D11,D11-C11)*24

HTH,
Elkar

 

[Guest]

It looks like it works. Thanks so much.

Try this:

=IF(ISTEXT(C11),D11,D11-C11)*24

HTH,
Elkar

 

[ilia]

So how does the formula change if it's Comp, Vacation, or Holiday? If
it doesn't, use Elkar's solution. Or,

=IF(OR(C11="Sick",C11="Comp",C11="Vacation",C11="Holiday"),D11,D11-
C11)

Of course this displays error for any other non-numeric value in C11.