# Formula help

#### bevjohnson2

##### New Member
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.

Maybe try =\$A\$1-B3, etc.

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.

Thanks soooo much!!!

Replies
6
Views
210
Replies
4
Views
251
Replies
12
Views
394
Replies
7
Views
262
Replies
8
Views
347

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.

### Which adblocker are you using?

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

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