Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Multiply Column Of Numbers By Fixed Number

1. I agreed to these rules
Join Date
1st March 2008
Posts
13

## 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. ## Re: Multiply entire column by fixed numbers

Edit>Paste Special - Operation

3. ## 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.

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

#### Posting Permissions

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