| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
It looks like it works. Thanks so much.
"Elkar" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make this work? =IF(C11=TEXT,D11,D11-C11)*24
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| Cant make it work | New Users to Excel | |||
| can't make it work, I need help | Excel Worksheet Functions | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| how to make this work if sum=5+n2 then sum becomes the value of s. | Excel Discussion (Misc queries) | |||
Linear Mode
