Equals function
 

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

=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

Typo

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


--

HTH

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


"Dave Peterson" wrote in message
...
=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

Thank you, RP <vbg.

Bob Phillips wrote:

Typo

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

--

HTH

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

"Dave Peterson" wrote in message
...
=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

--

Dave Peterson

Sorry, should have changed it

Bob <ebg


"Dave Peterson" wrote in message
...
Thank you, RP <vbg.

Bob Phillips wrote:

Typo

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

--

HTH

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

"Dave Peterson" wrote in message
...
=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

--

Dave Peterson