I have a formula that I want to reverse, as follows:
Cell A1 = 7
Cell A2 = 4*
Cell A3 = £150
Cell A4 = 100
Cell A5 = 50
Cell A6 = 5%
*Note: Cell A2 is a function of Cell A1, which is an average (i.e. (7+6+5+4+3+2+1)/7); so for example if Cell A1 = 6, then cell A2 would be (6+5+4+3+2+1)/6 = 3.5 and so on.
Total sales =
Cell A7 = Cell A1 (7) x Cell A3 (£150) x Cell A4 (100) x (1- Cell A6 (5%)=95%) = £99,750
Cell A8 = Cell A2 (4) x Cell A3 (£150) x Cell A5 (50) = £30,000
Total of Cell A7 and Cell A8 (which is in Cell A9) = £129,750
So now I would like two formulas:
A formula to take total per Cell A9 and get back to cell A1, i.e. 7
A formula to take total per Cell A9 and get back to cell A2, i.e. 4
Thank you, Russell
Cell A1 = 7
Cell A2 = 4*
Cell A3 = £150
Cell A4 = 100
Cell A5 = 50
Cell A6 = 5%
*Note: Cell A2 is a function of Cell A1, which is an average (i.e. (7+6+5+4+3+2+1)/7); so for example if Cell A1 = 6, then cell A2 would be (6+5+4+3+2+1)/6 = 3.5 and so on.
Total sales =
Cell A7 = Cell A1 (7) x Cell A3 (£150) x Cell A4 (100) x (1- Cell A6 (5%)=95%) = £99,750
Cell A8 = Cell A2 (4) x Cell A3 (£150) x Cell A5 (50) = £30,000
Total of Cell A7 and Cell A8 (which is in Cell A9) = £129,750
So now I would like two formulas:
A formula to take total per Cell A9 and get back to cell A1, i.e. 7
A formula to take total per Cell A9 and get back to cell A2, i.e. 4
Thank you, Russell
