ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you subtract from the bank balance (https://www.excelbanter.com/excel-discussion-misc-queries/109613-how-do-you-subtract-bank-balance.html)

Palliative

how do you subtract from the bank balance
 
How do you subtract from the bank balance like when you put -300 i want it to
subtract from the balance below

JLGWhiz

how do you subtract from the bank balance
 
In the same cell if your balance is 900 you enter =900 - 300 your result of
600 will appear in the same cell when you press enter.

If you use two cells for the function and a third for the result, assuming
col A:

enter 900 in A1 and 300 in A2, In A3 type =A1 - A2 and press enter your
result will be in A3

"Palliative" wrote:

How do you subtract from the bank balance like when you put -300 i want it to
subtract from the balance below



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com