I have an extremely basic spreadsheet that I need to stop rounding and just look at numbers as having two decimal places.

I'm taking a currency gross and multiplying by 3%

then subtracting the 3% from the gross

My problem comes in when Excel looks at the number as having more than one decimal place and rounds up anyway, thus adding an extra .01 instead of just dropping it.

Here are my formulas please tell me of any solutions that may fix it or holes in my formulas.

=(C3*.03) to get my 3%

=(C3-D3) to get my Net

The cells are formatted to currency with 2 decimal places.

thanks

I believe the answer is to use the ROUND function in your calculations.

=ROUND(C3*.03,2)

You may want to round the product as well:

=ROUND(C3-D3,2)

Works perfect, thanks!