0

I have the following spreadsheet:

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.

Thank you.

1
  • Hi. Your Title mentions "cost price" but this isn't isn't mentioned in the body of the question. What's the relationship between Column B and Column C?
    – Tedinoz
    Aug 4 at 5:01

2 Answers 2

0

After deleting B2:B11 and C2:C11, put this formula in B2:

=index($B$1+$B$1*A2:A11)

and this other in C2:

=index($C$1-$C$1/1.1*A2:A11)

columns B and C will fill themselves

0

Try this formula:

Cell C1:=B11

Cell C2:=$C$1-($C$1/(1+.1)*A2)

2
  • it works, but only up to 10%. if I want to extend to 20%, not anymore. Aug 5 at 1:06
  • You specifically cited 1-10%. If you want to extend to 20% then you must reflect this in the formula. The equivalent formulas would be C1:=B21 (or "26400") and C2:=$C$1-($C$1/1.2*A2)
    – Tedinoz
    Aug 5 at 9:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.