Avoiding 0 result in formula

[martins]

I have 2 worksheets in a workbook, one called “header sheet” and one called “purchase ledger”.
In cell B9 on the header sheet I am capturing data entered on the “purchase ledger” sheet cell J39. e.g. ='Purchase Ledger'!J39

No problem as such except that when there is no data in J39 the result returns a zero in B9 – how can I avoid this so that a blank is returned?

[arthurbr]

I have 2 worksheets in a workbook, one called “header sheet” and one called “purchase ledger”.
In cell B9 on the header sheet I am capturing data entered on the “purchase ledger” sheet cell J39. e.g. ='Purchase Ledger'!J39

No problem as such except that when there is no data in J39 the result returns a zero in B9 – how can I avoid this so that a blank is returned?

Hi Martins,
this question has been asked and answered many times on the forum.
Use "search" to find a relevant thread
Cheers

[VBA Noob]

Couple of options

1) Tools > options > View tab > untick zero values. This turns off all zero in sheet
2). Custom format the cells as

0;;

3). Use a if statement
http://www.j-walk.com/ss/excel/usertips/tip010.htm

VBA Noob

[martins]

option 2 is working for me - thanks