Simple Formula Issue

[bamaisgreat]

I have a labor sheet to keep up with my hours each week. The cells below are were Im having trouble.

I4 simply has the number of planned hours for each work which is 45

J4 adds all the hours I have entered for each day the formula is =sum(B4:H4)

Then the K4 is were my problem is. I have =I4-J4 in that cell. I want K4 to stay blank until I have over or under the hours in I4

Thanks

 

[Joe4]

I want K4 to stay blank until I have over or under the hours in I4

Not sure what you mean by that. Are you saying that you want to hide K4 if it is returning zero?
If so, try:

=IF(I4<>J4,I4-J4,"")

 

[FormR]

I want K4 to stay blank until I have over or under the hours in I4

Hi, is it this?

=IF(J4=0,"",I4-J4)