Formula help

bevjohnson2

New Member
Joined
Sep 30, 2006
Messages
2
Hi,
I have four cells with numbers in them. I need to figure out how to subtract those numbers from a number in another cell (in another column) and put the results in four other cells:

Cell A1 has the number 1000.

Cells B3-B6 have four different numbers in them. I need to subtract each number from the one in A1 and put the results in cells B8-B11.

Can anyone help??

Many Thanks!!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
In B8, simply enter the formula:

=A1-B3

and so on for the other formulas.
 
Upvote 0
Tip:

As you are entering =A1-B3 in B8, press F4 while the cursor is between the A1 and the minus sign, then enter -B3

Your formula will now look like =$A$1-B3

After you enter it, re-select cell B8, then grab the lower right corner of the cell and drag this down to where you want to end (B11 in this case).

For this four cell exercise, this doesn't save much time, but you certainly don't want to manually enter the formula if you have 100 cells.

The difference between A1 and $A$1 is that if you copy =A1-B3 to cells below by dragging the lower right corner, you will get A2-B4, A3-B5, etc. However, you want to keep the "A1" portion of your formula unchanged, but allow the Bs to increment. $A$1 is referred to as an absolute cell reference, and in this case keeps the "A1" portion of the formula unchanged as it is copied to other cells: A1-B4, A1-B5, etc.
 
Upvote 0

Forum statistics

Threads
1,217,763
Messages
6,138,459
Members
450,139
Latest member
myexcel202424

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