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. =/

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!