deleted reference
Cheekycow wrote:
Hello, In a template I am designing I have a summary tab with
formulas that reference amounts from several different detail tabs.
However, my beta testers sometimes delete a few of these detail tabs
as superfluous if there is no data to input in them. How do I write
my formula on the summary tab so that it still works (totaling the
amounts from the non-deleted tabs) even if one of the referenced
detail tabs is deleted? (Right now the formula on the summary tab
shows #REF! because it can't find one of the tabs.) It is almost as
if I need to write an "IF" formula in the event that one of the
referenced cells no longer exists. Thanks
Hi,
I think you could use something like this:
=IF(ISERROR(your_formula);"";your_formula)
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|