display an empty cell

  • Thread starter Thread starter Lynn
  • Start date Start date
L

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
 
=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
 
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
 
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
 
Back
Top