Best Answer

If I get this right you know the volume of sales for this year and know the percentage that it changed since last year and need to know the volume of last year?

First, you need to know what percent of last years volume that this years volume is, if not ...

let's say it increased by x% then this year the volume is 100+x% of last year or

if it decreased by x% then this years volume is (100-x)% of last year

Second,

volume this year = percentage change* last years volume

percentage means per 100 and "of" means multiply

so for example if this year the volume is 150 and it increased by 50%

then your percentage of last year is 150

150 = 150/100 * last years volume

150 = 1.5 * last years volume

150/1.5 = last years volume

100 = last years volume

Hope this helps..

Q: You have the current volume of sales and percent change vs a year ago but you need to calculate the year ago volume is there a formula or macro to get this done?

Write your answer...

Submit

Still have questions?

Related questions

(Final-Initial)/(Initial) is the formula for percent change (multiply by 100 to make it a percentage) I think this is what you are looking for.

100 %

Change in velocity / time

Charge flow can be calculated by multiplying the current (in amperes) by the time (in seconds) for which the current flows. The formula is Q = I * t, where Q is the charge flow in coulombs, I is the current in amperes, and t is the time in seconds.

Subtract the previous year from the current year. Take that amount and divide by the previous year's amount. That will give you the percent. Example: Current assets 2010 550,000 2009 533,000 Increase of 17,000, percent increase is 3.2%

Using the equation of percent of change.(Original Value - Current Value) / Originalvalue *100% = Percent change(60 - 36 ) / 60 *100 = 40%40% is the percent change

just multiply for the current currency like right now its 13.9971

Power = Current * Voltage Power = Change in work/change in time

You can calculate the percent change in mass by subtracting the initial mass from the final mass, dividing that result by the initial mass, and then multiplying by 100 to get the percentage. The formula is: ((Final mass - Initial mass) / Initial mass) * 100.

100*(New Length/Old Length - 1)

The formula to calculate pH slope is ΔpH/Δlog[H+], where ΔpH is the change in pH and Δlog[H+] is the change in the log concentration of hydrogen ions. This formula is used to determine the sensitivity of a pH electrode.

Percent change is the percent amount some value has changed. It has phenomenal usage in every day math and in fields such as business. It's often used to calculate the percent difference in sales between years for business.