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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lynn" wrote in message news:f33d1e97-2147-4cd3-85e2-e401382fefdf@x3g2000yqa.googlegroups.com... > 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
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 "Lynn" wrote in message news:f33d1e97-2147-4cd3-85e2-e401382fefdf@x3g2000yqa.googlegroups.com... >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
