Formula in a table header

  • Thread starter Thread starter Doug
  • Start date Start date
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?
 
=if(import!$q2="","",import!$q2)

(If Q2 on the import sheet is empty, then you'll see that 0.)
 
It still returns a 0 and there is something in the cell. It is actually Q1, I
typed Q2 by mistake.
 
For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2
 
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
 
Back
Top