MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hidden Cell Value


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

My problem is I have a payroll spreadsheet. I have figured the Soc. Sec. column using a formula with percentage. When I then subtract the Soc. Amt from the gross pay amt I get a penny off as the calculation does not account for the rounding up of the Soc. Sec. amount. It seems to be using the hidden value with full decimals. How do I fix it to use the displayed value of Soc. Sec.???


Posted by Richard S on February 13, 2002 3:23 PM

Precision as Displayed

Tools menu, options, Calculation tab, tick Precision as Displayed. Care, permanently loses accuracy.
Richard