Hi
I'm loosing my hair over this one, and it would be greatly appreciated if someone can assist me with this problem. I need excel to dynamically adjust the "Sell Price" value, so that my "Profit" value is kept at a fixed value, for example 20.
I'm loosing my hair over this one, and it would be greatly appreciated if someone can assist me with this problem. I need excel to dynamically adjust the "Sell Price" value, so that my "Profit" value is kept at a fixed value, for example 20.
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2 | D2 | =SUM(B2+(B2*C2)) |
E2 | E2 | =SUM(D2-B2) |