Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 364
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set total amount for an equation..... hln Excel Discussion (Misc queries) 5 July 24th 08 06:21 AM
What equation will total number of cells with specific words? Tidejwe Excel Worksheet Functions 3 June 5th 08 07:27 AM
Total sum based on different costs for each new quantity group Tboogie21 Excel Worksheet Functions 3 January 26th 07 12:56 PM
Sum total costs for multiple entries Dark_Templar Excel Discussion (Misc queries) 4 May 10th 06 04:57 PM
ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL Krysy Albutt Excel Worksheet Functions 1 April 21st 05 11:52 AM


All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"