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="H oliday"),D11,D11-
C11)

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


On Oct 23, 6:57 pm, Me wrote:
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?