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?

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?

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?

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?

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?

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?

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?