Community archive

Ask something
Discussion Locked

Excel Formula

0 helpful
3 replies

by lf king

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

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.

3 replies

by dklippert

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)

by lf king

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.

This discussion is closed to new replies.