Oops I had already changed it to rounding to ,2 when I saw it as correct.

--
__________________________________
HTH

Bob

"Luke M" wrote in message
...
You number of digits to round (formula declaration) is incorrect.
=ROUND(B12/$B$10,2)

Note that I didn't know what you were dividing, but I'm assuming the
normal
division yielded a value of 17.9%, which is what you're wanting to change
to
18%
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"SunshineinFt.Myers" wrote:

The formula above is rounding to high. For example: I want 17.9 % to
round to
.18 so that my conditional formatting color will change. I tried ,.05 and
it
changes my value to 0.0. Any ideas would be very appreciated for I am at
work
now and trying to solve this issue.