Hi,

IF A2 is the referce cell for the if formula & reuslt cell is A1,

If i cut A2 Row & palce it in A3 the refrence cell should be to the same
place.

Please help me in solving the same.

Thanks & Regards,
Manjunath

Try just copying A2 to A3 (or row 2 to row 3) and then deleting the
contents of A2 (or row 2).

Hope this helps.

Pete

On Dec 9, 1:12*am, Help!!!!!!!!!!
wrote:
Hi,

IF A2 is the referce cell for the if formula & reuslt cell is A1,

If i cut A2 Row & palce it in A3 the refrence cell should be to the same
place.

Please help me in solving the same.

Thanks & Regards,
Manjunath

Hi,

That depends on what you mean by reference cell should still be the same.
If you cut and paste a cell all references to it follow it. If you copy and
paste a reference cell none of the formulas that refer to it are transfered
to the new cell, they will all reference the original cell.

And whether you are doing this for a cell or a row makes no difference.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Help!!!!!!!!!!" wrote:

Hi,

IF A2 is the referce cell for the if formula & reuslt cell is A1,

If i cut A2 Row & palce it in A3 the refrence cell should be to the same
place.

Please help me in solving the same.

Thanks & Regards,
Manjunath

One other ponder, maybe something like this:
In A1: =IF(INDIRECT("A2")="","",INDIRECT("A2"))
A1 will always point to what's in A2,
regardless of what you do "physically" with A2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Help!!!!!!!!!!" wrote:
IF A2 is the reference cell for the if formula & result cell is A1,
If i cut A2 Row & place it in A3 the reference cell should be to the same
place