Saturday, May 21, 2011

yogi_Calculate X Percent Of A Number Which Then Is Successively Decreased By Y Percent

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
andie856603 said:
what formula do i need to calculate 75% of a number which then decreases by 90%
i also need to do with this also is add another value...yes the original number will stay the same but where would i enter the column/row to show if it was the 1st/2nd/3rd etc calcution of this number ie 1 would be 75% of original then 2 90% of that 3 90% of 2..... 4 90% of 3 and so on.

I believe I have answered this question from Andrea before ... in any event here we go again. I have generalized it though by using variable percentages A and B rather than the static values of 75% and 90%