ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH
That rounds to .18 for me, what do you get?
--
__________________________________
HTH
Bob
"SunshineinFt.Myers" wrote in
message ...
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.
|