Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to eliminate _ before a cell address in a formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to eliminate varying spacings betwen text? | Excel Discussion (Misc queries) | |||
Excel 2002: How to eliminate empty spaces ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to eliminate the time value after the date ? | Excel Discussion (Misc queries) | |||
Excel 2002: How to eliminate space within a cell and count items? | Excel Discussion (Misc queries) | |||
How to eliminate empty rows in Excel 2002 worksheet ? | Excel Discussion (Misc queries) |