I have the following spreadsheet:
For column B, the formula is simple: B1 + (B1 * A2)
The question is: how to get the numbers in column C?
I manually typed all values on column C but the idea is if I type 24200 on C1, it calculates all the other values.
24200 - 10% = 21780
21780 is 220 less than the initial price of 22000.