Return a blank cell instead of a zero value for two linked sheets.
 

I have a producion summary linked to individual invoices. If the production
summary has no orders, how can I alter the linked cell to return a blank
rather than a zero in the individual orders?
Currently the value in the cell is ='SPOON ORDERSHEET'!I11

Thanks for your help

Return a blank cell instead of a zero value for two linked sheets.
 

hi,
one way....
=if('spoon ordersheet'!I11=0,"",'spoon ordersheet'!I11)
the formula will show in the formula bar but if the other cell is 0, the
cell will display blank.

regards
FSt1

"Matt" wrote:

I have a producion summary linked to individual invoices. If the production
summary has no orders, how can I alter the linked cell to return a blank
rather than a zero in the individual orders?
Currently the value in the cell is ='SPOON ORDERSHEET'!I11

Thanks for your help