| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
row of $ numbers don't crossfoot
a list of employee pay is being multiplied by the medicaid, ss and disability
rates to end with a net pay assuming no fed or state withholding. the formula for the net is the gross less the three calculated tax results. the result net pay is off by a penny in several cases probably due to rounding in the formula but i can't figure out how to resolve. -- gary e |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row of $ numbers don't crossfoot
J.E. McGimpsey explains it and offers a solution:
http://mcgimpsey.com/excel/pennyoff.html gary e wrote: a list of employee pay is being multiplied by the medicaid, ss and disability rates to end with a net pay assuming no fed or state withholding. the formula for the net is the gross less the three calculated tax results. the result net pay is off by a penny in several cases probably due to rounding in the formula but i can't figure out how to resolve. -- gary e -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row of $ numbers don't crossfoot
In Superman 3, Richard Pryor resolved this by pocketing the difference and
becoming an evil genius... but that did not work out well in the end. I would use the Round() function "gary e" wrote: a list of employee pay is being multiplied by the medicaid, ss and disability rates to end with a net pay assuming no fed or state withholding. the formula for the net is the gross less the three calculated tax results. the result net pay is off by a penny in several cases probably due to rounding in the formula but i can't figure out how to resolve. -- gary e |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting | Excel Worksheet Functions | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Linear Mode
