Hi,
I'm using Excel 2003. I have a table with values entered and then a total at the right corner. I would like to turn the numbers in each of these cells into a percentage of the total value in cell O17, which has a value of 318.
For example, cell B10 shows a value of 4. I would like to know what percentage of 318 (Cell O17) is 4 (Cell B10). What would be the best formula to apply to all cells in the table except cell O17?
My second problem is that I also want the value 4 to show next to the percentage. 4 is 1.26% of 318. But in the same cell, Cell B10, I want the value 4 and 1.26% to show alongside each other. Is there any way to do that?
Thank you for all help you give me,
Alboi
I'm using Excel 2003. I have a table with values entered and then a total at the right corner. I would like to turn the numbers in each of these cells into a percentage of the total value in cell O17, which has a value of 318.
For example, cell B10 shows a value of 4. I would like to know what percentage of 318 (Cell O17) is 4 (Cell B10). What would be the best formula to apply to all cells in the table except cell O17?
My second problem is that I also want the value 4 to show next to the percentage. 4 is 1.26% of 318. But in the same cell, Cell B10, I want the value 4 and 1.26% to show alongside each other. Is there any way to do that?
Thank you for all help you give me,
Alboi