Software

Ask something
Discussion Locked

Formula

0 helpful
6 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

=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.

6 replies

by lf king

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

by dklippert

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)

This discussion is closed to new replies.