Percentage calculation

**Sophie10** · 11-07-2013, 08:06 PM

Hello,

I have an Excel issue that's probably very easy for you to solve...
Please look at the Excel file in attachment.
At the left you see a column with profit/loss percentages.
I'm now trying to find a formula that "processes" that percentage on the number in the column at the right of it (actually 1 line higher at the right).
We start with 1000. First there's a 0% profit, so the number stays 1000. Then there's a 17% loss. So the 1000 becomes 830 and so on...

Can someone please help me with this?

Thanks a lot in advance!

Natalia

**TMS** · 11-07-2013, 08:12 PM

B2:

Formula:

Please Login or Register  to view this content.

and drag down. Tails off to zero at row 187.

Regards, TMS

**FDibbins** · 11-07-2013, 08:15 PM

Hi and welcome to the forum

I think this is what you want, in B2, copied down...
=B1+(B1*A2)

**mehmetcik** · 11-07-2013, 08:18 PM

enter this formula in b2 and fill down

Please Login or Register  to view this content.

**Sophie10** · 11-08-2013, 07:48 AM

Thank you all for the quick replies!
The formula of FDibbins is the one I was looking for

**TMS** · 11-08-2013, 07:56 AM

They all do the same thing

But, you're welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Percentage calculation

LinkBack

Thread Tools

Rate This Thread

Display