@thomaster
Alright so here's the thing let me show you
I don't really need help I just need reassurance that im doing this right
hold on
here's the directions
and thats what I did
so am I just supposed to multiply to get the savings?
It doesn't provide me with any savings numbers
I can only see part of the assignment. I understand you have to use the spreadsheet to sum the expenses up?
Yes
So how did you do that?
I didn't sum them up yet I just put them in the spread sheet
I just sumed up the expenses for each month
how? with a calculator?
Yes....
I think the purpose of the assignment is to let excel calculate everything. So for expenses in October, you could put the following in the formula bar. =150+50+60+40+30 That would result in 330 without losing the original sum.
You still there? @Mr.Ick
For the next part you will have to put your bank balance in a random cell. Then click D3 and type = in the formula bar. Then click the cell where you've put the current savings balance. Then type +(B3-C3) What will happen: the formula will first calculate what's between parenthesis. B3-C3 for october will be 550-330 = 220. 220 is what's remaining in October. Then it will add that remaining money to the savings balance. 5600+220 = 5820. That will be displayed in the savings column.
Thanks we'll I guess I got it wrong then
It's not very complicated, you just have to understand how the easy formulas in excel work. I'll draw it to make it more clear.
|dw:1397685042871:dw|
Join our real-time social learning platform and learn together with your friends!