# Simply subtract .

#### Sunline

##### Well-known Member
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
ABC
1Elle2Elle2poResult
2149022
3246822
4344743
5444248
6543951
7643060
8741575
9840189
109322168
Sheet1

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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

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
ABC
1Elle2Elle2poResult
2149022
3246822
4344743
5444248
6543951
7643060
8741575
9840189
109322168
Sheet1
How did you get 2 results of 22 at the top of column C?

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

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
ABC
21490_
3246822
4344743
5444248
6543951
7643060
8741575
9840189
109322168
Sheet1

This formula entered in C3 and copied down:

=B\$2-B3

Thanks very much , exactly what i needed .

Thanks very much , exactly what i needed .
You're welcome. Thanks for the feedback!

Replies
1
Views
256
Replies
1
Views
172
Replies
1
Views
589
Replies
3
Views
247
Replies
8
Views
496

1,211,792
Messages
6,104,000
Members
447,889
Latest member
birdman15

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back