General discussion

Locked

Excel Formula

By LF King ·
I'm linking information from one worksheet to another within one file. i.e On Monthly sheet I want week 1's information to show in this cell.

So I want to write the formula to enter the information, but leave cell blank if no information is thereto link in.

What I have ='Week 1'!S17
But if the cell is blank it puts in a zero. I want to cell blank if there is no information.

This conversation is currently closed to new comments.

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

All Comments

Collapse -

Excel Formula

by DKlippert In reply to Excel Formula

Two suggestions:
Go to Tools>Options and remove the check mark from "Zero values" on the View tab.
or
use a formula like:

=If(Week1!S17=0,"",Week1!S17)

Collapse -

Excel Formula

by LF King In reply to Excel Formula

Gotten rusty with the new job, unmarking the Zero Values did the trick. The formula listed tries to open another workbook when the sheet is in the same workbook.

Collapse -

Excel Formula

by LF King In reply to Excel Formula

This question was closed by the author

Back to Community Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums