LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Finding Percentage

I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12


Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it. Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

--
Thank you,
Eric Vogel

 
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
Calculating a percentage with the end percentage in mind Shadowshady Excel Discussion (Misc queries) 2 June 17th 06 09:41 AM
percentage Piggy Excel Worksheet Functions 0 February 18th 06 09:53 AM
Finding the percentage difference of two or more numbers slr Excel Worksheet Functions 5 January 26th 06 02:00 PM
percentage Supersaint Excel Discussion (Misc queries) 2 January 11th 06 06:27 PM
Bar Chart depicting the "percentage of another percentage(less than 100)" TEAM Charts and Charting in Excel 1 October 28th 05 05:06 AM


All times are GMT +1. The time now is 05:50 AM.

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

About Us

"It's about Microsoft Excel"