income minus expenses, equal balance for the year
my device is an iPad Pro need formula to calculate on the yearly basis expenses minus income equal balance.
my device is an iPad Pro need formula to calculate on the yearly basis expenses minus income equal balance.
That's a remarkable broad question.
Where is your data? what does it look like?
Do you have a column of data for income, and another for expenses?
Or do you have one column of data for both (using +/- values for income vs. expense)?
Do you have separate tables per year, or one long list of expenses?
As a stab in the dark, I'm going to suggest that a pivot table is going to do this for you, but without knowing more about how your data is structured, there's almost no way to answer your question directly.
income minus expenses, equal balance for the year