Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel Formula Question(s)...

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel Formula Question(s)...

Old 12-12-03, 10:24 AM
  #1  
DVD Talk Limited Edition
Thread Starter
 
Join Date: Sep 2000
Location: CT
Posts: 5,177
Likes: 0
Received 0 Likes on 0 Posts
Excel Formula Question(s)...

hello all,

not too familiar with using formulas in excel, and there's a couple things i can't figure out...

i'm trying to figure out percentages. basically, i want Column C to express what percent Column B is of Column A (only for that particular row, but i want it to be for each row on the sheet)...

if that doesn't make sense:

if A1=100, B1=25, then C1 should say 25%.
if A2=200, B2=100, then C2 should say 50%

i know it's prolly a stupid/easy question, but thanks for the help...
Old 12-12-03, 10:36 AM
  #2  
DVD Talk Gold Edition
 
Join Date: Dec 1999
Posts: 2,708
Likes: 0
Received 0 Likes on 0 Posts
What about something like =ROUND(((B1/A1)*100),0) and have the column named percent (%)

Last edited by Lampei; 12-12-03 at 10:39 AM.
Old 12-12-03, 04:01 PM
  #3  
DVD Talk Legend
 
Minor Threat's Avatar
 
Join Date: Jul 2000
Posts: 13,739
Likes: 0
Received 0 Likes on 0 Posts
Or (simplified)

=A2/A1 (change cell format to %)
Old 12-12-03, 04:07 PM
  #4  
DVD Talk Legend
 
Join Date: Oct 1999
Location: |-|@><0r [email protected]|)
Posts: 17,214
Likes: 0
Received 0 Likes on 0 Posts
Better still:

=RC[-1]/RC[-2]

...and change column C to percentages (select column, Format Cells/Column, select the Number tab, and select Percent.)

- David Stein
Old 12-12-03, 11:40 PM
  #5  
DVD Talk Legend
 
Join Date: Aug 1999
Location: Chicago, IL
Posts: 17,205
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by Fernana
Or (simplified)

=A2/A1 (change cell format to %)
This is the easiest way to do this.

Seems like your a real Excel n00b. If you're going to be using it a lot, I'd recommend a basic Excel class -- you can get one for as cheap as $50-70.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.