Adding multiple cell totals

's Computer Specifications

I would like to make a short spread sheet that would for example, start with
a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or so
lines. Any suggestions would be helpful as usual.
Thanks

's Computer Specifications

A1: 1000
A2: =A1*(1+x%)*(1-n%)
you supply numbers for x and n
Copy down the column

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"D" <(E-Mail Removed)> wrote in message
news:91B5A877-F292-49EA-B112-(E-Mail Removed)...
>I would like to make a short spread sheet that would for example, start
>with
> a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or
> so
> lines. Any suggestions would be helpful as usual.
> Thanks

's Computer Specifications

Thanks, works well..

"Bernard Liengme" wrote:

> A1: 1000
> A2: =A1*(1+x%)*(1-n%)
> you supply numbers for x and n
> Copy down the column
>
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "D" <(E-Mail Removed)> wrote in message
> news:91B5A877-F292-49EA-B112-(E-Mail Removed)...
> >I would like to make a short spread sheet that would for example, start
> >with
> > a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or
> > so
> > lines. Any suggestions would be helpful as usual.
> > Thanks
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
getting totals mutiply cell by another cell then adding all togeth	texansgal	Microsoft Excel Worksheet Functions	3	2nd Jun 2009 02:36 AM
Adding totals of cells depending on contents of another cell	David	Microsoft Excel Discussion	2	6th Dec 2008 10:10 PM
Adding invoice totals with multiple records showing totals	Mike Koop	Microsoft Access Reports	1	10th Jan 2008 05:28 PM
Adding up multiple worksheets by name and totals	=?Utf-8?B?S2lsbGVy?=	Microsoft Excel Worksheet Functions	5	2nd Jan 2007 11:05 AM
Adding Multiple Totals in Excel	berny	Microsoft Excel New Users	3	30th Jun 2006 04:53 PM