Rounding Up

[Tricia]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have created a simple spreadsheet to use as a timesheet. The formula I created to calculate FICA and Medicare sometimes "rounds up" (e.g., $2,750 x 1.45% = $39.875, which Excel rounds up to $39.88). Is there something I can do to prevent this rounding up?

 

[CyberTaz]

The result of the calculation is only "rounding up" for display purposes &
doing so only because of the formatting applied to the cell. Use Format>
Cells> Number - Currency to set the decimal display to whatever display
accuracy you prefer. Regardless of the formatting, full accuracy is retained
& used in further calculations.

If this doesn't provide what you need you'll have to be more specific about
what you *do* want rather than what you don't want

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Phillip Jones, C.E.T.]

Wouldn't when setting places for Monetary use 3 places or 4 places
instead of two

Then on the very last item or total just show to two places?

The result of the calculation is only "rounding up" for display purposes &
doing so only because of the formatting applied to the cell. Use Format>
Cells> Number - Currency to set the decimal display to whatever display
accuracy you prefer. Regardless of the formatting, full accuracy is retained
& used in further calculations.

If this doesn't provide what you need you'll have to be more specific about
what you *do* want rather than what you don't want

HTH |:>)
Bob Jones
[MVP] Office:Mac

--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto[email protected]
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.phillipmjones.net
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------

 

[JE McGimpsey]

Wouldn't when setting places for Monetary use 3 places or 4 places
instead of two

Then on the very last item or total just show to two places?

Taxes, FICA, etc., often have specific rounding rules. Carrying extra
digits isn't always appropriate.