Suppose I have an Excel sheet with cell A1 = 1000, A2 = 950, A3 = 775, B1 = 625, B2 = 595 and B3 = 410.
If cell A5 = 2, what formula should I type in cell A6, so that A6 = 950 which is the value in cell A2. If I were to type value 3 in cell A5, then cell A6 = 775, the value in cell A3. Thank you for your time.
If cell A5 = 2, what formula should I type in cell A6, so that A6 = 950 which is the value in cell A2. If I were to type value 3 in cell A5, then cell A6 = 775, the value in cell A3. Thank you for your time.