Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Multiply Column Of Numbers By Fixed Number

  1. #1
    Join Date
    1st March 2008
    Registered Users

    Multiply Column Of Numbers By Fixed Number

    I just found this website because I'm stumped. I did a search myself, then went through the 5 pages the "Post" function brought up. I'm sure it's been asked before, I must just not be using the right words

    I need to tell every cell in one column to multiply itself by a firm number and a percentage.

    Ex: Column F will be the result of $77.80 times 75 percent all the way down the column. Column G will be $27.21 times 100 percent all the way down.

    I could enter the formula into every cell, but I wondered if there's a way to just tell the whole column, only once, what it needs to do. Thank you so much for your help!

    PS-I work for an insurance company. The employees of a company want a spreadsheet showing exactly who pays exactly what. Ex: Their paystub shows $142.90 coming out of their paycheck. Their employer pays 100% of medical, 75% of dental. The columns would show Total, Employer Medical, Employer Dental, Employee Medical, Employee Dental. I hope that makes sense. =/
    Last edited by txheart; March 1st, 2008 at 06:05.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

  3. #3
    Join Date
    23rd October 2003
    Alsace France
    Super Moderators

    Re: Multiply Column Of Numbers By Fixed Number

    I got Edit > Paste Special > Formula to copie a formula to a complete range.
    Parhaps could you have a look in the file attached using named cells.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Triumph without peril brings no glory: Just try

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Count the number of unique Numbers in a column
    By ajajmannen in forum Excel General
    Replies: 11
    Last Post: December 15th, 2010, 00:27
  2. Multiply Corresponding Numbers & Return Sum of Those
    By BorneoHornbill in forum Excel General
    Replies: 3
    Last Post: July 28th, 2007, 16:28
  3. Multiply Strings & Numbers
    By VashApollo in forum Excel General
    Replies: 6
    Last Post: November 30th, 2006, 07:15
  4. Subtract Number From Column of Numbers
    By sean9023 in forum Excel General
    Replies: 3
    Last Post: October 4th, 2006, 23:01
  5. Multiply by different numbers
    By 4Given in forum Excel General
    Replies: 6
    Last Post: September 21st, 2005, 04:17


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts