You can use function offset. See excel help for better uderstanding Fill this to A1 and drag down. =OFFSET(A1;0;2)+OFFSET(A1;0;4)+OFFSET(A1;0;6)-OFFSET(A1;0;3)-OFFSET(A1;0;5)-OFFSET(A1;0;7)UpdateSorry, I have non-English version of the Excel where ; are as separation character in formulas. In English Excel is it probably with , =OFFSET(A1,0,2)+OFFSET(A1,0,4)+OFFSET(A1,0,6)-OFFSET(A1,0,3)-OFFSET(A1,0,5)-OFFSET(A1,0,7)
Square and cube roots Click here to reveal answer
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4). |