MemphisBigDog
New Member
- Joined
- Mar 31, 2010
- Messages
- 4
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??
Thanks!!
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??
Thanks!!