How to round off number after multiplication??

This is a discussion on How to round off number after multiplication?? within the Excel Questions forums, part of the Question Forums category; OK, this might be an easy question for someone other than myself. I am a beginning excel user who is ...

How to round off number after multiplication??

OK, this might be an easy question for someone other than myself. I am a beginning excel user who is having a difficult time getting my spreadsheet to do right.

I am multiplying a salary by a percentage. I have the destination column for the answer in accounting format so it will will only display 2 numbers to the right of the decimal point and put the dollar sign in etc.

However, when I go to sum all of the entries in the destination column, it gives be a figure but it is usually off by 1-2 cents.

I figure that it has something to do with a rounding issue.

Can anyone give me an example formula of how to multiply a column X a percentage & round off the resulting number to 2 digits to the right of the decimal point so when I go to add the column it gives me the correct number??