i have a sheet set up to give me certain formulas for our payroll tax. for instance,
these are the numbers that show in the columns, they seem to rounded up on their own when needed, which is what i want.
column c = gross = 270.00
column d = Fed 15% = 40.50
column e = SS 6.2% = 16.74
column f = mc 1.45% = 3.92
column g = State 6% = 16.20
column i = Net = 192.65
the problem is this: i have a "Totals" column so that I know how much to send to the IRS each month. It does not add the rounded up figures "shown" but adds the un-rounded figures some how. the problem is that over time these figures are coming up wrong.
for instance, the mc 1.45% column shown above is actually 3.915. after several of these columns, my figures are wrong. take a look.
Date: gross: mc 1.45% shown in cell mc 1.45% actual
3.1.07 1000.00 14.50 14.50
3.5.07 270.00 3.92 3.915
3.12.07 100.00 1.45 1.45
3.19.07 50.00 .73 .725
3.26.07 50.00 .73 .725
totals 21.32 21.315
it gets worse... if you add all of the "shown" mc column, it is actually 21.33
here is the formula i am using for the "Total MC 1.45%" cell =SUM(F3:F60) now i have another problem, i am suppose to match the s.s. tax and the medicare, so i have another cell that is suppose to simply multiply the "Total MC 1.45%" cell by 2. here is the formula i use for that cell. =K10*2 it says that 21.32 x 2 = 42.63 this is how i discovered this mess in the first place.
i hope this is understandable, as i know it's a bit hard to explain without seeing it. any help would be really great, as this is my first month to begin doing this and i need to get this thing right.
thanks in advance.
Bookmarks