Thread: How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Me Me is offline
external usenet poster
  
Posts: 67
Default How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
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