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

 

[John Wilson]

joe pt,

You can change your original formulas;

= yourformula

to

= IF(ISNA(yourformula),"",yourformula)
You can replace the "" with a 0 if you want.

John

 

[joe pt]

Thanks! works Great