Blank instead of 0

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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)
 
=if(sheet1!a1="","",sheet1!a1)

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)
Click to expand...
 
Back
Top