| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Functions Help
I have a time sheet calculating comp t time used if hours worked (G18) under
8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
Try it this way:
=IF(OR(G18=0,G188),0,8-G18) Hope this helps. Pete On Oct 13, 4:46*pm, Swtmelly wrote: I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) * If the employee doesn't work then I'm also getting answer '8'. *How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
One way:
=IF(COUNT(G18),IF(G188,0,8-G18),"") -- Biff Microsoft Excel MVP "Swtmelly" wrote in message ... I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
=IF(G18="","",IF(G188,0,8-G18))
-- David Biddulph "Swtmelly" wrote in message ... I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
=(G8<8)*(G80)*ISNUMBER(G8)*(8-G8)
-- John C "Swtmelly" wrote: I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
We have a WINNER!! Thank you so much!
"John C" wrote: =(G8<8)*(G80)*ISNUMBER(G8)*(8-G8) -- John C "Swtmelly" wrote: I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested Functions Help
You are welcome, and thanks for the feedback (all the other responses would
work too). Don't forget to check the little YES box below :) -- John C "Swtmelly" wrote: We have a WINNER!! Thank you so much! "John C" wrote: =(G8<8)*(G80)*ISNUMBER(G8)*(8-G8) -- John C "Swtmelly" wrote: I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work then I'm also getting answer '8'. How can I fix the formula so that if there are no times logged in or out I can get the answer '0.00' or a blank cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Functions | Excel Worksheet Functions | |||
| Nested Functions | Excel Discussion (Misc queries) | |||
| nested if(and) functions | Excel Discussion (Misc queries) | |||
| Nested Functions | Setting up and Configuration of Excel | |||
| Too many nested functions | Excel Worksheet Functions | |||
Linear Mode
