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