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

M

Me

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?
 
I

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top