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

M

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste Formula-dropping 1st cell address 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula without cell address 6
Not able to drag formula to successive cells 2
Function to determine if a cell contains a formula 5
How to reference the formula in a cell. 3
return a formula instead of a value of a cell 4
check first 3 characters of a cell and compare to a table 4

Top