Funding 2
Then, we’ll create our first formula here. Highlight D15 type equal, then add to formula data from C15 then divide this on 100. It is percentage and then multiple with D12. And here we have interesting situation. We need here the fixed data. I mean if we will be copying formulas we should to fix the value of this cell. How we can do it. It is very easy, we just type a special symbol $ - dollar. If we put this symbol before title of column, in our case - it is D, than we will fix column. If we put this symbol before title of rows, in our case - it is12, than we will fix rows. Also we can put this symbol 2 times and block this cell in formula. We need block only rows, cause when we will by copying our formulas down we should keep value of D12 cell.
Then we create the new formal in cell - total. Here we will be have the same algorithm as total in previous sheet. So we do a summary D15 and total of previous day, and then subtract outcome for today. Here we go. We have our first fund.
my suggestion - highlight by color D15 and F15, to show, that this cells work automatically.
Then we copy this head of a table 4 times be this way.
Let s be sure that you will not go over budget while you dividing money on your funds.
look how I do this
equal 100 hundred minus this this this this and this. And thats how you can check yorself, when you ll be changed values and try to find your own effective type of funding.
so my suggest to you
12 - dividends
3 - savings
30 - salary
15 - marketing
40 - content (rent, good sales, internet and other)
Then we will do total cell of funds. Highlight S 15 and do a summary of total each funds. Look how I do it. How you will be work with this table, I ll tell you later. But before this we will do penultimate step, We will create check cell.
.
Search from various English teachers...
Corrections · 0
Don’t miss out on the opportunity to learn a language from the comfort of your own home. Browse our selection of experienced language tutors and enroll in your first lesson now!
Start Learning Today
