Hidden Cell Value Problem

Posted by Ann on February 13, 2002 2:32 PM

Okay...there is probably an easy answer to this but I don't know it. I have made a payroll spreadsheet. My soc. sec. column is figured with a forumula using a percentage. When I subtract this from the gross pay to get net pay, instead of using the rounded number it uses a value with the full number of decimals. How do I fix this??

Posted by Barrie Davidson on February 13, 2002 5:43 PM

Is your "soc. sec. column" rounded? I mean, if this column is calculated as =A1*33%, do you have the formula as =ROUND(A1*0.33,2) or is the formula simply =A1*0.33?

BarrieBarrie Davidson