ExcelBanter - Blank instead of 0

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Blank instead of 0 (https://www.excelbanter.com/excel-discussion-misc-queries/214792-blank-instead-0-a.html)

Craig

Blank instead of 0

Sheet2 references Sheet1

Sheet2
A1 = Sheet1!A1

When a Sheet1 cell is blank I would like a blank in Sheet2 instead of a 0

I have tried the following If statement but keep getting errors.

=IF(Sheet1!A1 isblank, "", Sheet1!A1)
--
Thanks!

Craig

Dave Peterson

Blank instead of 0

=if(sheet1!a1="","",sheet1!a1)

Craig wrote:

Sheet2 references Sheet1

Sheet2
A1 = Sheet1!A1

When a Sheet1 cell is blank I would like a blank in Sheet2 instead of a 0

I have tried the following If statement but keep getting errors.

=IF(Sheet1!A1 isblank, "", Sheet1!A1)
--
Thanks!

Craig

--

Dave Peterson

All times are GMT +1. The time now is 10:44 PM.