Subtraction Formula

[coliervile]

I want to use a subtraction formula that doesn't refer to cell references...the normal way in cell D9 =C9-B10. Is there another way with out the cell references (C9 and B10) maybe an offset or something other that would be in cell D9?

Thanks,
Charlie

 

[crook_101]

Hi,

Try,

=OFFSET(D9,0,-1)-OFFSET(D9,1,-2)

Cheers,
Ian

 

[jeffreybrown]

Deleted...

 

[T. Valko]

I want to use a subtraction formula that doesn't refer to cell references...the normal way in cell D9 =C9-B10. Is there another way with out the cell references (C9 and B10) maybe an offset or something other that would be in cell D9?

Thanks,
Charlie

You can try this but I don't see how it's better than =C9-B10.

=OFFSET(D9,,-1)-OFFSET(D9,1,-2)

 

[coliervile]

Thanks Crook_101 and T. Valko for your ideas but, is there anyway of doing it without any cell references- not even to cell D9?

Thanks,
Charlie

 

[crook_101]

hi,

Offset needs a "starting point" so offset is out - can I ask why you are doing this - even if you find a solution it will be so much more inefficient....

Ian

 

[T. Valko]

Thanks Crook_101 and T. Valko for your ideas but, is there anyway of doing it without any cell references- not even to cell D9?

Thanks,
Charlie

If you don't use any cell references at all how would you tell Excel what cells to calculate?

 

[jeffreybrown]

My first thought, make a couple of defined named ranges.

Cellone = C9
Celltwo = B10

D9 = Cellone-Celltwo

 

[coliervile]

I want to copy a row of data and paste it into a new row that I've inserted into the worksheet that will do some basic subtraction and division without using cell references but, the offset to do the subtraction and division remains the same fromrow torow...does this make since?

Charlie

 

[coliervile]

I find it that copying data and putting it into new rows sometimes the formula cell references get out of wack and i want to prevent this from happening...if that's possible.

Charlie