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

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Blank instead of Zero 9
Why does Excel think blank = zero ? 17
Blank cell instead of zero 5
need formula returning a blank cell 4
Sumproduct - Return value as Blank 3
Vlookup and Trace Return Cell 2
trying to make a cell either blank or zore value 4
Display of Date in Linked Cell 3

Top