D
Doug
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?
It returns a 0.
How can I get it to return the correct value?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=if(import!$q2="","",import!$q2)
(If Q2 on the import sheet is empty, then you'll see that 0.)
(If Q2 on the import sheet is empty, then you'll see that 0.)
D
Doug
It still returns a 0 and there is something in the cell. It is actually Q1, I
typed Q2 by mistake.
typed Q2 by mistake.
D
Doug
For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2
returns deletes =Import!$Q2
G
Gord Dibben
Are you using Excel 2007 and Insert>Table?
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
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