O Office 2004 Test Drive User Oct 18, 2006 #1 I need to calculate the percentage of a number in a specified period. Can excel calculate a percentage of an occurence?
I need to calculate the percentage of a number in a specified period. Can excel calculate a percentage of an occurence?
N Niek Otten Oct 18, 2006 #2 <Can excel calculate a percentage of an occurence?> Yes. But I think you need to be more specific to get any helpful answer. What exactly are you trying to do? -- Kind regards, Niek Otten Microsoft MVP - Excel |I need to calculate the percentage of a number in a specified period. Can | excel calculate a percentage of an occurence? |
<Can excel calculate a percentage of an occurence?> Yes. But I think you need to be more specific to get any helpful answer. What exactly are you trying to do? -- Kind regards, Niek Otten Microsoft MVP - Excel |I need to calculate the percentage of a number in a specified period. Can | excel calculate a percentage of an occurence? |
J joeu2004 Oct 18, 2006 #3 Office said: I need to calculate the percentage of a number in a specified period. Can excel calculate a percentage of an occurence? Click to expand... Not sure what you mean. It would be better to provide a numerical example. If you want to compute 10% of a number in A1, then simply: =A1*10% If you want to compute what percentage B1 is of A1, then: =B1 / A1 If you want to compute the percentage difference between A1 and B1, then: =B1 / A1 - 1 (Caveat: For the latter two, A1 and B1 must both be positive or both be negative. And A1 cannot be zero.) In all cases, format the cell as Percentage with the desired number of Decimal Places. Click on Format > Cells > Number and select Percentage.
Office said: I need to calculate the percentage of a number in a specified period. Can excel calculate a percentage of an occurence? Click to expand... Not sure what you mean. It would be better to provide a numerical example. If you want to compute 10% of a number in A1, then simply: =A1*10% If you want to compute what percentage B1 is of A1, then: =B1 / A1 If you want to compute the percentage difference between A1 and B1, then: =B1 / A1 - 1 (Caveat: For the latter two, A1 and B1 must both be positive or both be negative. And A1 cannot be zero.) In all cases, format the cell as Percentage with the desired number of Decimal Places. Click on Format > Cells > Number and select Percentage.