Need help with Excel
 

I have a file that has 2 colums.

Colum A Colum B

They both have to 2 numbers in them

So it looks like

Colum A Colum B
50032 20012

I need to make Colum C and have it be what % Colum B is of Colum A

So it will be like

Colum A Colum B Colum C
50032 20012 78%

Anyone know how to do this?

In C column: =(b1/a1)*100

fill down.

?

In column c put + and click on column b then / click on column a then enter
it should place a formula in column c that results in the percentage (you have to format the cell to get the % to show correctly). You can then copy this cell's formula to the other cells below it in the same column.

Hmm when I do both of what you guys said it says #VALUE!

Have any idea what I am doing wrong?

The colums are named R (main value) S (supposed to be what # % of the main value is) and T (the % value).

I am putting in =(S1/R1)*100 into the T colume and it it says #VALUE! I have formated it as % also.

I got it to work using =SUM(S2/R2) on the number 2 row. Is there a way to make it automaticly put in the row number IE

=SUM(S3/R3)
=SUM(S4/R4)

I have about 200 rows to do ;/

If you use the pull down feature it should change the value on each line to match the line you're on. You don't have to type each one.

Cyn

What is the pull down feature?

I dont' use excel often

select the bottom right corner, hold down mouse click and drag down the column