Simply subtract .

[Sunline]

Hello all , im wanting to get a function that will subtract from cell B2 always .
Results are in col C.
Cell B2 needs to be locked (not sure of the right term to use).
Subtract B3 from B2 =22
Subtract B4 from B2 =43
Subtract B5 from B2 =48
Subtract B6 from B2 =51
Etc

Thanks .

Excel Workbook
	A	B	C
1	Elle2	Elle2po	Result
2	1	490	22
3	2	468	22
4	3	447	43
5	4	442	48
6	5	439	51
7	6	430	60
8	7	415	75
9	8	401	89
10	9	322	168
Sheet1

 

[ret44]

Just need to set up the formula the right way:
=$B$2-b3

The dollar signs make the reference absolute, so it doesn't change

 

[T. Valko]

Hello all , im wanting to get a function that will subtract from cell B2 always .
Results are in col C.
Cell B2 needs to be locked (not sure of the right term to use).
Subtract B3 from B2 =22
Subtract B4 from B2 =43
Subtract B5 from B2 =48
Subtract B6 from B2 =51
Etc

Thanks .

Excel Workbook
	A	B	C
1	Elle2	Elle2po	Result
2	1	490	22
3	2	468	22
4	3	447	43
5	4	442	48
6	5	439	51
7	6	430	60
8	7	415	75
9	8	401	89
10	9	322	168
Sheet1

How did you get 2 results of 22 at the top of column C?

 

[Sunline]

Thanks for replies , yes that was a mistake to have two results of 22 there .

 

[T. Valko]

Thanks for replies , yes that was a mistake to have two results of 22 there .

Ok, then do you want it to be like this:

Book1
	A	B	C
2	1	490	_
3	2	468	22
4	3	447	43
5	4	442	48
6	5	439	51
7	6	430	60
8	7	415	75
9	8	401	89
10	9	322	168
Sheet1

This formula entered in C3 and copied down:

=B$2-B3

 

[Sunline]

Thanks very much , exactly what i needed .

 

[T. Valko]

Thanks very much , exactly what i needed .

You're welcome. Thanks for the feedback!