ExcelBanter - displaying an empty cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - displaying an empty cell (https://www.excelbanter.com/excel-programming/430633-displaying-empty-cell.html)

Lynn[_7_]

displaying an empty cell

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

Eduardo

displaying an empty cell

Hi,
=if(Sheet1!C6="","",Sheet1!C6)

"Lynn" wrote:

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

All times are GMT +1. The time now is 12:43 PM.