General discussion

Locked

Formula

By LF King ·
=IF(ISBLANK(Alexander!D25),"",Alexander!D25)
The formula above was written to move information from multiple worksheets into a master worksheet and display a blank cell when no information is listed. BUt, when you delete a cells information from the individual sheets it changes the master to a #REF!. Is there anyway to keep this from happening. Or would it be better to just link the cells and turn off the Zero option.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Formula

by DKlippert In reply to Formula

Try:
=IF(ISBLANK(INDIRECT("Alexander!D25")),"",INDIRECT("Alexander!D25))

Collapse -

Formula

by LF King In reply to Formula

I understand the functions, but excel keeps telling me there is an error in the formula. I'm not seeing it. Please help

Collapse -

Formula

by DKlippert In reply to Formula

Sorry, typo. The Indirect parameter needs quotes, I left out the last " mark. Try this:

=IF(ISBLANK(INDIRECT("Alexander!D25")),"",INDIRECT("Alexander!D25"))

(watch out for spaces. This forum inserts extra spaces in long lines)

Collapse -

Formula

by DKlippert In reply to Formula

There should not be a space in the 2nd Alexander.

Collapse -

by LF King In reply to Formula

Poster rated this answer.

Collapse -

by LF King In reply to Formula

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums