Rounding up numbers

[ryanLJ]

Hello Everyone. This is my first thread. Here is my problem:

I have a list of data, showing as currency, that is found by multiplying two numbers together. Even though the currency shows as two decimal points, the "actual", excel number has many more decimals points that it refers to.

And the problem is that when I add this list of numbers together I get a total that is derived from adding the "hidden" decimal points that are beyond the 2 decimal points you see in "Currency" setting.

This is problematic for me. I need the list of data to actually add up to the amount that it shows with two decimal points.

How can I do this?

Thanks,
Ryan

 

[barry houdini]

Hello Ryan, welcome to MrExcel

You can use round function, e.g. if you are multiplying the value in A1 with the value in B1 try this to round to 2 decimal places

=ROUND(A1*B1,2)

 

[ryanLJ]

That's great! Thank you very much.

Ryan