calculating percentages in Excel

  • Thread starter Thread starter Robert Torbert
  • Start date Start date
R

Robert Torbert

How can I calculate percentages between two numbers; i.e.
the percentage of 1 (a value in cell B45)to 4 (a value in
cell B44) = 25% (percentage that I want to calculate and
show in cell B46)
Is it not possible to use simple division in Excel?
 
=B45/B44

Format the cell as % under Format > Cells > Number tab

HTH
Jason
Atlanta, GA
 
-----Original Message-----
How can I calculate percentages between two numbers; i.e.
the percentage of 1 (a value in cell B45)to 4 (a value in
cell B44) = 25% (percentage that I want to calculate and
show in cell B46)
Is it not possible to use simple division in Excel?
.
Click to expand...
Simple division works... and gives you 0.25. Once you set
the cell to "percent style" from the menu, you would then
see: 25%

Stephane
 
Back
Top