# Reverse Percentage calculation

#### Scruffy77

##### New Member
Hello all,
This is more of a math issue, but thought this would be the best place to start.

I want to be able to figure out what the percentage value would be if I want to incease \$17.65 to \$21.91 using mutiple step progressions.

For Example, between 17.65 and 21.91
I want to apply an X% onto 17.65 on June 1 to create a new amount, then want to apply another X% on Oct 1 to the new amount, to get a ANOTHER new amount,
The goal being the final NEW AMOUNT will be 21.91 as of a certain date.
Anyone know how to figure out the multiple percentages?

Any assistance would be greatly appreciated.
Thanks!

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
I guess it depends on how often you are compounding your interest, but just based on how you stated your problem, I'd say is this:

FinalAmount = InitialAmount * ( 1 + Interest ) ^ n

where 'n' is the number of times that you have applied the interest. You can then solve for 'Interest'.

Try

(End Value / Beg Value)^(1/num of periods) - 1

to get your percentage. Specific adjustments can be made if required (simple interest, annual rate, differing compounding, etc.)

Thanks for the info, I tried Jay's and it works perfectly

S you know, the values are houly wage rates
My company want's to get an employee wage to \$21.91 over X amount of percentage increases over a year (FROM \$17.65) and I need to present my bosses with a couple of options and this will help greatly!!!

Thanks to you both!!

Replies
3
Views
226
Replies
6
Views
301
Replies
0
Views
172
Replies
2
Views
648
Replies
0
Views
592

1,196,515
Messages
6,015,660
Members
441,913
Latest member
Lhayden_69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back