=if('sheet1'!a1="","",'sheet'1!a1)




Natalie wrote:

Hi,

I am trying to create a spreadsheet using the = function.

Ie,

To populate date in A1, it should equal 'Sheet1'!A1.

How do I get it to show a blank cell in A1 if Sheet1A1 is blank? It is
currently showing a 0?

Thanks

--

Dave Peterson