Remove the Zero number in blank fields

[net]

Hello,

Can someone tell me what I am doing wrong with this formula?

​

=IF(J1487="","",(K1487-J1487()))


I am trying to remove the "0" number in a blank cell.

I am calculating the number of days a workorder was open. I subtract the close date from the open date (K1487-J1487) which works fine. The problem is, a "0" appears in the "Total Days" column if there are no rows to calculate. I am trying to remove the "0" to a empty field.

What am I doing wrong?

Appreciate your help.

 

[shades]

Howdy.

=IF(J1487=0,"",(K1487-J1487()))

If it is the zero you want to "eliminate", then use the above.
________
Ford Foundation History

 

[HaHoBe]

Hi, net,

I pretty much doubt the formula not to work - I would have guessed

=IF(J1487=0,"",K1487-J1487)

Ciao,
Holger

 

[net]

Thanks to the both of you for responding to my problem.

Holger, your formula worked. I appreciate your time.