My wife and I are decent on excel but couldn't figure this one out...

Here is an example of one of my rows:

I'm trying to calculate from within a cell a percentage (6.33%) times
an integer (2,097). What Excel is returning is 186, when it should be
returning 185.91. Also 98.11 rounds down to 98. Any ideas to get Excel
to stop rounding my numbers?

I have the cell set to two decimal places, I've tried many formats
general, number accounting and they all do the same thing.

Thanks in adavance!

First, when I multiply 6.33% * 2097, I get 132.7401.

Are you sure you're looking at the correct formula?

==
And some other comments.

If you format the cell as general and make the column wide enough, then you
should see all the decimals. If the column is too narrow to show all the
decimal places, excel will round the display (not the actual value, though).

If you format the cell as number with 2 decimal places and shrink the column to
only show only the whole part of the answer, you should see ######'s. If you
widen the column, you'll see everything.

wrote:

My wife and I are decent on excel but couldn't figure this one out...

Here is an example of one of my rows:

I'm trying to calculate from within a cell a percentage (6.33%) times
an integer (2,097). What Excel is returning is 186, when it should be
returning 185.91. Also 98.11 rounds down to 98. Any ideas to get Excel
to stop rounding my numbers?

I have the cell set to two decimal places, I've tried many formats
general, number accounting and they all do the same thing.

Thanks in adavance!

--

Dave Peterson