Ok, here's what I am doing. I am taking the values of two cells, dividing
them with the IMDIV function and I have tried several methods to round it to
two decimal places, all of which have failed.

1. Using round coupled with the IMDIV function. EX: =ROUND(IMDIV(B2,C2),2).
This method chooses to round everything either up or down, depending if it is
greater than or less than .5 (I also have the cells formatted to 2 decimal
places)
2. Just formatting the resulting cell values to 2 decimal places yields no
rounding at all.
3. Using just round and the cells I want calculated: =ROUND(B2/C2,2) yields
the same as method 1. I have also tried using -2 instead of two with no luck.

"Tyro" wrote:

You still refuse to supply the underlying cell value, the rounding method
you use, if rounding with a formula, and the format you applied to the
cell.
I am not a mind reader.

Tyro

"Snake2135" wrote in message
...
I should have elaborated better. After more screwing with it, it seems as
though no decimal will round to two places. 7/8 comes out to .875, 5/4
results 1.25 as they should, but the formula refuses to round.

"Snake2135" wrote:

By solid result I mean something that divides cleanly (not a whole number
quotient), such as 5/4 = 1.25

"Tyro" wrote:

Please explain: "But on repeating decimals it will not round, only on
solid
results it will round to two decimal places". Show us an example.
What is a "solid result"? Are you saying that 1.456456456 does not
round to
1.46? And that 1.456123789 does round to 1.46?

Tyro

"Snake2135" wrote in message
...
here's my situation: I need to round all decimals that result from an
IMDIV
function to two decimal places. I have Excel 2007, I have already
tried
numerous ROUND functions, formatted the cells to round to two decimal
places.
But on repeating decimals it will not round, only on solid results it
will
round to two decimal places, thanks in advance.