I feel really stupid for asking this question but i don't know where to find out how to do it.
I have a number is columns A, B and C
Say in column A i have 1000, column B is 30000 and column C is 10000.
In column D and E i want to know (in number format) what percentage of column A goes in these columns. I would expect column D to have 666.66 and column E to have 333.33.
I know it's a simple sum but i really can't remember the math to find out these numbers.
Can anyone please remind me how to do this?
I have a number is columns A, B and C
Say in column A i have 1000, column B is 30000 and column C is 10000.
In column D and E i want to know (in number format) what percentage of column A goes in these columns. I would expect column D to have 666.66 and column E to have 333.33.
I know it's a simple sum but i really can't remember the math to find out these numbers.
Can anyone please remind me how to do this?