Negative result to show as blank cell

[Claudio]

I have a formula that calculates work times, but when there are no entries
for that day, it displays a negative result (-0.50), then that result is
reflected on the actual time sheet which is linked to that cell. I want to
have that result shown as a blank cell on J11.
This is the formula I am using;
=MIN($H$2,H4)

I tried this conditional formatting string, but it doesn't work:
=(J11<=0,"")

Claudio

 

[Biff]

Hi!

If there are no entries how can the formula cell return -
..50? There has to be an entry somewhere that is causing
the formula to return a value.

You need to find out why the formula cell is returning -
..50 and correct the problem at the source. Don't try to
correct the problem after it's propagated to downstream
calculations.

Biff

 

[Trevor Shuttleworth]

Claudio

=IF(MIN($H$2,H4)<0,"",MIN($H$2,H4))

Regards

Trevor

 

[Dave R.]

Conditional formatting in this case should work with a true/false statement.
If TRUE, your format gets applied. If false, it doesn't.

Note that conditional formatting only changes appearance and that negative
value could still be involved in other calculations.

The conditional formatting statement is
=J11<=0
format text as same color as background.

For a formula, one way is:

=IF(MIN($H$2,H4)<=0,"",MIN($H$2,H4))

Which may work depending on what is in H2 and H4.

 

[Claudio]

Thank you for your response, there are no manual entries, but this is a time
period calculation sheet, and Excel puts in times automatically, obviously
these are overwritten when actual times are entered. This is happening only

 

[Claudio]

Thank you Trevor, but that didn't work, I am pretty certain that I had tried
that already, but I tried it again just in case, but no good.

Thank you,
Claudio

**************************************>

 

[Claudio]

Thank you Dave, that I can do, but the result is still being picked up and
subtracted from the other time results giving me an incorrect sum.
Claudio

 

[Biff]

Hi!

I see that none of the replies has solved the problem. Are
there formulas in H2 and H4? What formula are you using to
calculate the time?

You said that the times are automatically "put in" by
Excel. Do you mean the times are
automatically "calculated" by use of a formula?

It sounds to me like =MIN(H2,H4)is the formula in J11 but
what is/are the formulas that return the values in H2 and
H4? I think that's where your problem is.

Biff