Uncalculated values":

[Sarah Ford]

How do I hide uncalculated values.

 

[Dave Peterson]

I think that it depends on what you mean by an uncalculated value.

 

[Lauren]

Dave I have not entered the cell reference info. The information will be
entered at a later date when the data become available. At this time the
values are reflecting #N/A. The #N/A I would like to hide. I only want
the calculated value to appear after I enter the cell reference data.

You prompt reply was and is appreciated.

 

[Dave Peterson]

I'm not quite sure what you're doing, but this might work for you:

=if(iserror(yourformula),"",yourformula)

You may be able to make the iserror(formula) smaller than the real formula, but
that would depend on what you're doing.