# Subtract from existing Balance using positive integers

#### RRico

##### Board Regular
Hey yall.

If Cell A1 contains a balance of "300," how would I write the formula so that all numbers I place in A2, A3, etc... will change A1 to countdown accordingly?

Example:

A1 = 300
Then,
B1 = 1, which turns A1 into a value reading of 299

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### BAlGaInTl

##### Well-known Member
You would need to put a formula in A1.

Something like

=300-SUM(A2:A1000)

Where A1000 would be a range far enough down to cover all your entries

This works Well!

Thank you!

Replies
2
Views
209
Replies
1
Views
309
Replies
3
Views
709
Replies
3
Views
757
Replies
0
Views
279

1,195,680
Messages
6,011,122
Members
441,586
Latest member
rodsin76

### 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