Excel 2002 : How to eliminate _ before a cell address in a formula

Hi,

I am working on a report generated by a business system In Excel Format.

The table in the Excel file is a Sub Total Table that is expandable.

I need to manipulate on the data of the expanded table, however noted that
the formula below could not work as I copy downwards. The second and third
argument of the formula is fixed by "_" before the cell address E17 and D17.

=IF(LEFT(P10,1)="5",_E17,-_D27)

Also I find that when I move the cursor to the cell for the 2nd and 3rd
argument, the resulting cell address that appears in the formula is not the
cell that my cursor stop and comma it ?

May I know why and how to overcome this problem ?

Thanks

Low

I would guess that _E17 and _D17 are defined names.

Change them to cell addresses after you see what ranges they refer to.


Gord Dibben MS Excel MVP

On Fri, 2 Apr 2010 05:38:01 -0700, Mr. Low
wrote:

Hi,

I am working on a report generated by a business system In Excel Format.

The table in the Excel file is a Sub Total Table that is expandable.

I need to manipulate on the data of the expanded table, however noted that
the formula below could not work as I copy downwards. The second and third
argument of the formula is fixed by "_" before the cell address E17 and D17.

=IF(LEFT(P10,1)="5",_E17,-_D27)

Also I find that when I move the cursor to the cell for the 2nd and 3rd
argument, the resulting cell address that appears in the formula is not the
cell that my cursor stop and comma it ?

May I know why and how to overcome this problem ?

Thanks

Low