Thread: How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
Try this:

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

HTH,
Elkar


"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?
Reply With QuoteReply With Quote