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,

If the relative cell references remain the same and you just copy and paste the formula it will then refer to the new references, Using your example above:

in cell D9 =C9-B10

copy the formula from D9 to D10 and you will have =D9-B11

Cant understand why this wouldn't wotk, maybe it's too late over here?/

Ian

 

[coliervile]

Here's an example of my worksheet:
If I insert a new row, Row 2, below Row one to input the daily numbers and copy another row the cell references get messed up. Any ideas to make this easier would be greatly appreciated.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Date	G	$ Change	% Change	F	$ Change	% Change	C	$ Change	% Change	S	$ Change	% Change	I	$ Change	% Change	Best Return	Least Return
2	15-Oct-07	$12.16	0.00	0.0000%	$11.58	0.01	0.0864%	$17.39	0.14	-0.7986%	$21.04	0.21	-0.9882%	$25.74	0.10	-0.3870%	F	S
3	12-Oct-07	$12.16	0.00	0.0000%	$11.57	0.01	-0.0864%	$17.53	0.08	0.4585%	$21.25	0.13	0.6155%	$25.84	0.10	0.3885%	S	F
4	11-Oct-07	$12.16	0.00	0.0000%	$11.58	0.00	0.0000%	$17.45	0.09	-0.5131%	$21.12	0.17	-0.7985%	$25.74	0.04	0.1556%	I	S
5	10-Oct-07	$12.16	0.01	0.0823%	$11.58	0.01	0.0864%	$17.54	0.03	-0.1707%	$21.29	0.02	0.0940%	$25.70	0.03	-0.1166%	S	C
6	9-Oct-07	$12.15	0.00	0.0000%	$11.57	0.00	0.0000%	$17.57	0.09	0.5149%	$21.27	0.09	0.4249%	$25.73	0.15	0.5864%	I	G
7	5-Oct-07	$12.15	0.00	0.0000%	$11.57	0.06	-0.5159%	$17.48	0.17	0.9821%	$21.18	0.32	1.5340%	$25.58	0.18	0.7087%	S	F
Funds