N
NChilds
Hello Everyone, I am new on the board and a bit of a novice on Excel.
tried to find an answer to my question before I posted it, bu
couldn’t. Thanks for any help or link you can extend.
I am using Excel 2000 and trying to calculate a spreadsheet of employe
benefits, whereby our company (PIC) pays a percentage of employe
health and life premiums.
The first set of columns contain the premium rate-per-month for eac
employee and their dependents, which are whole numbers. These number
total the exact amount of the benefit invoices. Perfect!
The second set of columns breaks out the percentage of premium th
company pays for each employee (75%) and dependents (25%), and totalle
into what PIC pays per month.
The third set of columns breaks out the percentage of premium eac
employee pays per month for themselves and their dependents, an
totalled.
The Problem is the final set of columns: Each amount and total i
halved for “Per Pay Period,” (we get paid twice per month), for bot
PIC and the employees. These numbers are no longer .25, .50, etc. ..
but .63, .48, .38, etc. When I use the @Sum function, it comes out to
slightly different number (cents-wise) than when I total each number i
the cell this way: +1092.50+560+65.63, etc., or use a calculator (lik
my boss does!). My chart is $.14 off per month, $.07 per pay period
For example, the total of the monthly column is $1,629.25, halved (wit
a formula) as $814.63. When the calculator is used (or added one b
one), they come out to $814.66.
How do I get Excel to correctly balance totals sideways and down. Thes
sums have to be exactly right to the penny because we need the correc
deductions to input into Quickbooks for each employee for health, life
disability, and dental. My boss said if I need to add a few pennies t
his benefit so no one has to pay more by the end of the year, that’
fine, but I don’t know where to input it so it will work out.
If we can get it correctly on the spreadsheet, then we can add o
delete employees as needed, the formulas will change the rates wher
necessary. Thank you and sorry for the length of this post ... I wa
trying to be precise as possible. I wouldn’t even mind emailing th
sheet for someone to look at it off-forum.
Thank you! Norene
(Hey, I just saw where I can attach a file! Here it is ... thank you!
Attachment filename: pic.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44550
tried to find an answer to my question before I posted it, bu
couldn’t. Thanks for any help or link you can extend.
I am using Excel 2000 and trying to calculate a spreadsheet of employe
benefits, whereby our company (PIC) pays a percentage of employe
health and life premiums.
The first set of columns contain the premium rate-per-month for eac
employee and their dependents, which are whole numbers. These number
total the exact amount of the benefit invoices. Perfect!
The second set of columns breaks out the percentage of premium th
company pays for each employee (75%) and dependents (25%), and totalle
into what PIC pays per month.
The third set of columns breaks out the percentage of premium eac
employee pays per month for themselves and their dependents, an
totalled.
The Problem is the final set of columns: Each amount and total i
halved for “Per Pay Period,” (we get paid twice per month), for bot
PIC and the employees. These numbers are no longer .25, .50, etc. ..
but .63, .48, .38, etc. When I use the @Sum function, it comes out to
slightly different number (cents-wise) than when I total each number i
the cell this way: +1092.50+560+65.63, etc., or use a calculator (lik
my boss does!). My chart is $.14 off per month, $.07 per pay period
For example, the total of the monthly column is $1,629.25, halved (wit
a formula) as $814.63. When the calculator is used (or added one b
one), they come out to $814.66.
How do I get Excel to correctly balance totals sideways and down. Thes
sums have to be exactly right to the penny because we need the correc
deductions to input into Quickbooks for each employee for health, life
disability, and dental. My boss said if I need to add a few pennies t
his benefit so no one has to pay more by the end of the year, that’
fine, but I don’t know where to input it so it will work out.
If we can get it correctly on the spreadsheet, then we can add o
delete employees as needed, the formulas will change the rates wher
necessary. Thank you and sorry for the length of this post ... I wa
trying to be precise as possible. I wouldn’t even mind emailing th
sheet for someone to look at it off-forum.
Thank you! Norene
(Hey, I just saw where I can attach a file! Here it is ... thank you!
Attachment filename: pic.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44550