#REF!

[Helen]

Hello,

I have some functions in my spreadsheet that returns "#REF!". That is OK,
however I'm wondering if there is a way to format the spreadsheet to not
display the "#REF!" but instead just a blank cell?

Thanks,

Helen

 

[Bob Phillips]

=IF(ISERROR(formula),"",formula)

substitute your existing formula in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Helen]

thanks. works great!



Helen

=IF(ISERROR(formula),"",formula)

substitute your existing formula in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Robert McCurdy]

I have some functions in my spreadsheet that returns "#REF!". That is OK,

I don't think it is OK Helen.
#REF! means the formula isn't working and unlike most of the other errors, won't go away if appropriate data is found.

It is caused either by the range or range name deletion, or the cut/insert of row/columns.
Hiding the formula is like sticking ones head in the sand. It needs replacing with one that is looking at the correct range.

Display the formula bar if not visible, select the Ref formula cell and if there is no #REF! in the formula, check it out with
Evaluate Formula from the Tools > Formula Auditing menu.
Otherwise you will need to rewrite the formula, usually by simply replacing #REF! with the correct range.


Regards
Robert McCurdy

Hello,

I have some functions in my spreadsheet that returns "#REF!". That is OK,
however I'm wondering if there is a way to format the spreadsheet to not
display the "#REF!" but instead just a blank cell?

Thanks,

Helen