I suspect that you are looking for the Math column.
If that doesn’t get you what you need, please elaborate on your question.
no i want Deposit withdraw and balance system
So you want a running total?
yes pls
You can use a Query column. The below video shows the general technique:
i don’t get it man that a lot of column i have only 4 can you
teach me or just show easier way
That is the easiest way, unless you want to write some code.
i have this code how do i use it
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sh = ss.getSheet()[0]
var carry
var row = sh.getLastRow()
var last = sh.getLastRow()-1
var deposit = sh.getRange(row,2).getValue()//ฝากเงิน
var withdraw = sh.getRange(row,3).getValue()//ถอนเงิน
var amount = sh.getRange(last,4).getValue()//ยอดคงเหลือ
if(row == 2){
sh.getRange(2,4).setValue(deposit)
carry = sh.getRange(‘E2’).setValue(deposit)
}else{
var balance = (deposit+amount)-withdraw
sh.getRange(row,4).setValue(balance)//ยอดเงินคงเหลือ
carry = sh.getRange(‘E2’).setValue(balance)//ยอดยกไป
}
}
Darren’s method would get you what you need, if English is not native to you, you can discuss what you get stuck with in your own language, we’ll try and help you get through that.
These methods can be intimidating for newcomers, but Darren explained it very well in my honest opinion, so please give it a try first.