adding or substracting number formulas

Really Confused

New Member
Joined
Aug 27, 2011
Messages
6
Help!!!! I've been trying to obtain the formula for adding to and subtracting from a original number such as in cell A1 the number is 100, the number in cell A2 is to be added to A1 and the number in A3 is to be subtracted from A1. Is there a formula to keep the number in A1?

eg. A1 - 100 then I add 50 in A2, now A1 is 150, A1 =IMSUB(A2,A3) is there a formula so that when I add or subtract (A3) that A1 automatically plus's or subtracts with out adding to A2 or subtracting from A3 to get the correct amount in A1?????

I'm using Excel 2010.

Thanks Really Confused
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,224,516
Messages
6,179,231
Members
452,898
Latest member
Capolavoro009

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