Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
Hello,
I'm working with multiple departments using different Excel documents for each dept due to security. Each team's document ties back to my master workbook via formulas. The master is shared with senior management and right now it is hard to read. Most of the data is fine but in cells where no data has yet been added, I'm getting values like a 0 for text fields or 1/0/1900 for dates. Is there a way to have incomplete cells remain blank on the master document until departments complete a cell? Their copies look fine. It's just the master that's a nightmare to read. thanks so much!
in my understanding i think this simple IF formula can help you
=IF('Department Sheet'!A1="","",'Department Sheet'!A1)