Calculation problem #N/A issue

[joe pt]

Hello,
Can someone tell me if the following is possible.

I am making a few basic calculations in a worksheet. Sometimes the
value returned is #N/A because a cell is blank. This is correct. Once
the cell is filled with a value the calculation is correct.

My question is: Is it possible to hide or show a blank or a user
defined value instead of #N/A?

Thanks