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...