Uncalculated values":

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top