I am very rusty with Excel so here goes...
I am using Excel 2007
I need to be able to devide the sum of cells E, G, I, K, M, O, Q, and S by Cell D and present the resukt in Cell A.
I would like the results presented in % rounded to 2 digits to the right of the decemil point. Such as 16.666666 would display as 16.67.
I will have many rows (256 of them) and want the formula to work the same in all rows starting with A2 and giving the results for that row seperately.
I tried
but didn't work. Like I said above, I am rusty with Excell.
I am using Excel 2007
I need to be able to devide the sum of cells E, G, I, K, M, O, Q, and S by Cell D and present the resukt in Cell A.
I would like the results presented in % rounded to 2 digits to the right of the decemil point. Such as 16.666666 would display as 16.67.
I will have many rows (256 of them) and want the formula to work the same in all rows starting with A2 and giving the results for that row seperately.
I tried
Code:
=(SUM=E+G+I+K+M+O+Q+S)/D