Equals function

[Guest]

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]

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

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

 

[Bob Phillips]

Typo

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


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Thank you, RP <vbg>.

Typo

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

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry, should have changed it

Bob <ebg>

Thank you, RP <vbg>.