Excel Percentage

  • Thread starter Thread starter S
  • Start date Start date
S

S

I am drawing a blank. I am developing a comprehensive budget and am required
to show the percentage for each of the expenditures. In the end, the
percentages should total to 100.

Example,

$66.00 out of $100.00 = 20%

$44.00 out of $100.00 = 10%

$33.00 out of $100.00 = 90%

I do not remember how to put formulate the formula in excel 2007.

Please help.
 
I don't understand your figures
but to get % of any number
enter the number in A1
percentage in B1 either as 0.10 for 10% or format it as a percentage and
enter 10
then enter this in C1
=A1*B1
 
Hi Sheeloo

Please allow me to re-explain.

I have three categories that should total to $500.00 and I additionally need
to show these values as percentages.

Category A is $66.00 (now I need to show $66.00 in the percentage phase is
X% of the $500.00).

So in the end, I am attempting to show the breakdown in the percentage value
for each of the categories.

I hope that I explained what I need to both of our understanding.

Thank you again.
 
Back
Top