Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Urgent Priority · Version 2003

Reply Tue 1 Jul 2008, 18:20Delegate Jourdan said...

Jourdan has attended:
Excel Intermediate course

Excel

i have a list of percentage changes to an amount of money.
Eg in 2001 my stock rose 10% in 2002 it dropped 5% etc.

it is just a list of percentages ranging back a few years now and all i have is this year current value.

How do i work out what each year was?
ie apply the percentage increase/decrease to each number

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Jul 2008, 09:47Trainer Carlos said...

RE: excel

Hi Jourdan

If I understand correctly

1.You only have the percentages from the past years but not the money amounts

2. For this year you have the money amount

In this scenario there is no way to discover the original numbers that gave you the percentages, unless these percentages are in anyway connected to the present value.

I hope this answers your question.

If not you could send a copy of the spreadsheet (relabelling or renaming any sensitive data) with an explanation of how the data works to

forum AT microsofttraining.net

After looking at te data I may have a better understanding of your problem and try to find a solution

Regards

Carlos

Excel articles

· Trust Excel To Protect Your Data
· Data Basics Using Excel
· Making The Most Of Filtering In Excel
· Want To Create A Presentation In Excel?
· What's mine is yours: Sharing data in Excel

Please browse our web site to find out more about
excel vba course london and other Microsoft training courses.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips