View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I make column C a percentage of column B

Hi,
not pretty sure what you want, you need column C to show percentage of B
based on a column B total ? if yes do

=B1$B$100

B100 = cell with the total
dopy formula down

if this is not what you were looking for please give an example thanks

"dbcruzin" wrote:

I need to calculate different percentages for fixed numbers I have in column
B. How do I make column C a percentage of B, column D a different percentage
of B, and so on.