I have spreadsheet similar to a check book register with debits and credits in different columns and then a third column with the running total. Example below
I would like to add a column with a checkbox so that it only changes the total column when that row has a checkbox. I would like to keep debits and credits in separate columns. Example below.
What would be the formula in running total column using an IF formula?
Hi GLS062866,
Enter the starting balance in D2.
Formula in D3 is IF(A3,D2−B3+C3,D2)
If the box in A is ticked ("TRUE") then calculate the new balance, else show the previous balance.
Regards,
Ian.
Hi GLS062866,
Enter the starting balance in D2.
Formula in D3 is IF(A3,D2−B3+C3,D2)
If the box in A is ticked ("TRUE") then calculate the new balance, else show the previous balance.
Regards,
Ian.
Hi Yellowbox,
Thank you for you help. Worked exactly the way I was wanting. Seams so simple but i guess I didn't have enough coffee. Thanks.
Using SUMIF in formula?
