|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
04-25-2005, 01:30 PM
|
#1 |
|
Confirmed User
Join Date: Jan 2005
Posts: 794
|
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?
__________________
I am a marketing Genius. |
|
|
|
04-25-2005, 01:40 PM
|
#2 |
|
Confirmed User
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
|
In C column: =(b1/a1)*100
fill down. ?
__________________
Your post count means nothing. |
|
|
|
|
04-25-2005, 01:40 PM
|
#3 |
|
Meow Media Inc.
Industry Role:
Join Date: Jul 2001
Location: In the valley of the sun, cactus, tacos, tequila, and nod
Posts: 7,785
|
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.
__________________
|
|
|
|
|
04-25-2005, 01:55 PM
|
#4 |
|
Confirmed User
Join Date: Jan 2005
Posts: 794
|
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 am a marketing Genius. |
|
|
|
|
04-25-2005, 02:00 PM
|
#5 |
|
Confirmed User
Join Date: Jan 2005
Posts: 794
|
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 ;/
__________________
I am a marketing Genius. |
|
|
|
|
04-25-2005, 02:21 PM
|
#6 |
|
Confirmed User
Join Date: Mar 2005
Location: The OC
Posts: 1,274
|
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 |
|
|
|
|
04-25-2005, 02:41 PM
|
#7 | |
|
Confirmed User
Join Date: Jan 2005
Posts: 794
|
Quote:
I dont' use excel often
__________________
I am a marketing Genius. |
|
|
|
|
|
04-25-2005, 02:43 PM
|
#8 |
|
In Tushy Land
Join Date: Oct 2002
Location: Nebraska
Posts: 40,149
|
select the bottom right corner, hold down mouse click and drag down the column
|
|
|
|
