Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Excel Worksheet Functions | |||
Finding the percentage difference of two or more numbers | Excel Worksheet Functions | |||
percentage | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |