I am new to formulas, so hopefully I will write this clearly enough to be understood.

I need to calculate a running balance, but only want a value to display if the row has a subtotal. In the subtotal column (column V) I have the formula =sum (xx:xx). That subtotal is to be subtracted from a starting balance, then each row from the remaining balance as the user completes rows (each row contains expenses by date). I have searched online, and found several formula options, but none leave the 'balance' column blank. What formula can I use to only show the “balance” if the “expenditures Subtotal” contains data (other than the formula).

In the screenshot below the formulas in column X are the formulas I entered in W6 and W7 in hopes of the field being blank if the Expenditures Subtotal is blank (column V).

enter image description here


You're close!

Use this:

=IF(V6="", "", W5-V6)

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.