ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Equation for total benefit costs = an additional __% of salary? (https://www.excelbanter.com/excel-worksheet-functions/203255-equation-total-benefit-costs-%3D-additional-__%25-salary.html)

SandyinMT

Equation for total benefit costs = an additional __% of salary?
 
I am using Microsoft Office 2007. How would I add two totals to get a
percentage of additional income. I am doing Benefit Statements for a company
with 50 employees. I have the spreadsheet set up and using Mail Merge to
merge the data from Excel into Word. I just can't figure out what the
equation is.

Sheeloo[_2_]

Equation for total benefit costs = an additional __% of salary?
 
If you the two values in A1 & B1 and additional income in C1 then to get the
percentage you can enter this in D1
=(A1+B1)/C1*100

"SandyinMT" wrote:

I am using Microsoft Office 2007. How would I add two totals to get a
percentage of additional income. I am doing Benefit Statements for a company
with 50 employees. I have the spreadsheet set up and using Mail Merge to
merge the data from Excel into Word. I just can't figure out what the
equation is.



All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com