display an empty cell

[Lynn]

I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?

thanks

 

[Bernard Liengme]

=IF(ISBLANK(Sheet1!C6),"",Sheet1!C6)
this will work when C6 is truly blank not when it has a formula that returns
a blank

=IF(Sheet1!C6="","",Sheet1!C6)
should work for you also

best wishes

 

[BRO]

Your problem is only a format problem. right click -- format cells (or
press Ctrl+1) in the "Number" tab, choose Custome, in the text box
enter the following format #,###.##

(the 1st one is a comma, the second one is a dot)

Please inform me if it works

 

[S. A. Stone]

A simple way is to use Conditional formatting, make the condition so that if
the cell is = to 0 then format the text color to match the color of that
cell.

SS