Simply subtract .

Sunline

Well-known Member
Joined
Oct 6, 2007
Messages
701
Office Version
  1. 2016
Platform
  1. Windows
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
 
Upvote 0
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?
 
Upvote 0
Thanks for replies , yes that was a mistake to have two results of 22 there .
 
Upvote 0
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
 
Upvote 0
Thanks very much , exactly what i needed .
 
Upvote 0

Forum statistics

Threads
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?

Disable AdBlock

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
Back
Top