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

[Mr. Low]

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

 

[Gord Dibben]

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