ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trying to get annual savings (https://www.excelbanter.com/excel-discussion-misc-queries/144461-trying-get-annual-savings.html)

dspencer

Trying to get annual savings
 
I have homework that is wanting to to use a formula to get the annual savings
of the cells that I have from the previous sheet. Anyone know how I might
go about this?????

Barb Reinhardt

Trying to get annual savings
 
What's in the cells from the previous sheets? It's difficult to answer
without that information.

"dspencer" wrote:

I have homework that is wanting to to use a formula to get the annual savings
of the cells that I have from the previous sheet. Anyone know how I might
go about this?????


dspencer

Trying to get annual savings
 


"Barb Reinhardt" wrote:

What's in the cells from the previous sheets? It's difficult to answer
without that information.

"dspencer" wrote:

I have homework that is wanting to to use a formula to get the annual savings
of the cells that I have from the previous sheet. Anyone know how I might
go about this?????


The homework was to do a sheet with two categories. One was expenses and
the other was income. I did all that and did the yearly totals. the second
sheet wants me to take the yearly totals and put them on the second sheet and
create a formula to give me the annual savings of the cells I moved. under
expenses I have 9 rows of yearly totals and the complete total and under
income I have two rows and a total.

I hope this will help
Dean

Sandy Mann

Trying to get annual savings
 
All basic economics theory can be ultimately traced to the simple principle
well stated in David Copperfield by Macawber - "My other piece of advice,
Copperfield,' said Mr. Micawber , 'you know. Annual income twenty pounds,
annual expenditure nineteen and six, result happiness. Annual income twenty
pounds, annual expenditure twenty pounds ought and six, result misery."

Isn't the answer required simply the Total Income minus the Total
Expenditure?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"dspencer" wrote in message
...


"Barb Reinhardt" wrote:

What's in the cells from the previous sheets? It's difficult to answer
without that information.

"dspencer" wrote:

I have homework that is wanting to to use a formula to get the annual
savings
of the cells that I have from the previous sheet. Anyone know how I
might
go about this?????


The homework was to do a sheet with two categories. One was expenses and
the other was income. I did all that and did the yearly totals. the
second
sheet wants me to take the yearly totals and put them on the second sheet
and
create a formula to give me the annual savings of the cells I moved.
under
expenses I have 9 rows of yearly totals and the complete total and under
income I have two rows and a total.

I hope this will help
Dean





All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com