HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
have a cell on sheet2 referencing a cell on sheet1
=Sheet1!B2
=iferror(sheet1!b2,"")
I would like to display a blank if the cell on sheet1 is blank but instead I get a 0
Can anyone help cheers
=Sheet1!B2
=iferror(sheet1!b2,"")
I would like to display a blank if the cell on sheet1 is blank but instead I get a 0
Can anyone help cheers