Excel - drop numbers after the decimal for use in function 1

[Doroth]

Greetings -

I am working on a spreadsheet wherein the "A" cells automatically increase by 3%. That number is than multiplied by another number. The problem I am running into is that the result is inaccurate, although it looks as if it should work.

I have column "A" showing up as currency with 2 decimal places. Further down in the list, the number that has resulted by the 3% increase shows as $37.81. The number I'm multiplying it by is 1500. Unfortunately, the number that is appearing as a result of the multiplication is 56,722.11 rather than the 56,715 that one would expect.

I've converted these cells to general formatting and see that the decimals beyond the two that show are still there being used in the calculation. Thus, the resulting number is accurate, but not what I need. I need to delete any fractions of a cent from use within the calculations.

Does anybody have an idea of how to go about this?

 

[Rofeu]

Hi,

something like:

=ROUND(Your_Number,2)

Cheers,

Roel

 

[Loomah]

other options to consider, depending on your actual requirement are
TRUNC
ROUNDDOWN &
ROUNDUP

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Doroth]

Thanks. I knew there had to be an easy fix - just didn't know how to do it. Kudos.