Do Not Display Zero

[deemer98]

Good morning all,

In a workbook, I have multiple work sheets that refer back to the 1st sheet (Sep 2021) to get its information. If I have a cell in Sep 2021 that I have not populated yet, I don't want to see a ZERO on any of the other cells in any other worksheet. But, I do want it to display a zero if I enter zero.

For example: Sheet "Flat Roller"....in cell B9, the formula is ='Sept 2021'!I9

'Sept 2021'!I9 is set up for me to enter a given number, but not until Sep 15 (that just happens to be the date that I will populate that cell)

So right now, for today through the rest of the month, on all my worksheets that refer to Sept 2021 for information, are displaying a zero and I simply want it to be blank until I enter data in Set 2021.

Hope that didn't confuse anyone. Please assist if you can and I appreciate it kindly!

David

 

[Joe4]

Try changing this formula:

='Sept 2021'!I9

to this:

=IF(LEN('Sept 2021'!I9)>0,'Sept 2021'!I9,"")

 

[deemer98]

It took the ZERO away, but it doesn't populate with whatever number I then enter into the Sept 2021 sheet

 

[deemer98]

Try changing this formula:

='Sept 2021'!I9

to this:

=IF(LEN('Sept 2021'!I9)>0,'Sept 2021'!I9,"")

Yes it does! I stand corrected! I have to put the info in the right cell to start with Thanks for your help!!!

 

[Joe4]

You are welcome.