trying to find the percentage increase/decrease using a formula

**FDibbins** · 12-17-2012, 11:39 PM

actually the basic math would be 1000/500 (or 500/1000 depending on what you are testing).
so the excel version of that would be =G36/G37 = .5

if you wanted to know this yr's contribution based on the last 2 years, then the formula would be

=g36/(g36+g37) =.66

**Modify_inc** · 12-18-2012, 01:13 AM

Originally Posted by FDibbins

actually the basic math would be 1000/500 (or 500/1000 depending on what you are testing).
so the excel version of that would be =G36/G37 = .5

if you wanted to know this yr's contribution based on the last 2 years, then the formula would be

=g36/(g36+g37) =.66

Thanks for the reply, even though I figured it out; any additional advice is always welcomed!