I am trying to put this in a table header cell "=Import!$Q2"
It returns a 0.
How can I get it to return the correct value?
--
Thank you!

=if(import!$q2="","",import!$q2)

(If Q2 on the import sheet is empty, then you'll see that 0.)

Doug wrote:

I am trying to put this in a table header cell "=Import!$Q2"
It returns a 0.
How can I get it to return the correct value?
--
Thank you!

--

Dave Peterson

It still returns a 0 and there is something in the cell. It is actually Q1, I
typed Q2 by mistake.

--
Thank you!


"Dave Peterson" wrote:

=if(import!$q2="","",import!$q2)

(If Q2 on the import sheet is empty, then you'll see that 0.)

Doug wrote:

I am trying to put this in a table header cell "=Import!$Q2"
It returns a 0.
How can I get it to return the correct value?
--
Thank you!

--

Dave Peterson
.

For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2
--



"Dave Peterson" wrote:

=if(import!$q2="","",import!$q2)

(If Q2 on the import sheet is empty, then you'll see that 0.)

Doug wrote:

I am trying to put this in a table header cell "=Import!$Q2"
It returns a 0.
How can I get it to return the correct value?
--
Thank you!

--

Dave Peterson
.

Are you using Excel 2007 and InsertTable?

Table headers cannot be formulas.

If you have a formula the formula will be changed to a static value when you
create the table.

You will be warned of this when you create the table.

If you try to enter the formula after you have created the table, it will
turn to 0................no warning.


Gord Dibben MS Excel MVP




On Wed, 11 Nov 2009 13:19:03 -0800, Doug
wrote:

For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2