Hey all, I've got a quick question for you in regards to percentages and excel.
I want to create a formula where I can have a starting value, say 500, and subtract it by a percent, and then take that answer and subtract it by the same percentage ad infinitum.
I'm using the "=A1*(1-A2/100)" formula (A1 is original value, A2 is percent value) in A3; is there a way to get Excel to then change the formula to "=A3*(1-A2/100)" without me having to manually change A1 to A3, A4, A5...?
I hope that makes sense.
Thanks for giving pause to read this and I look forward to any and all responses!
Bookmarks