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.

"SunshineinFt.Myers" wrote:
[Subject: =ROUND(B12/$B$10,1)]
The formula above is rounding to high.

What "formula above"? Oh, you mean the subject line. That is not always
visible or completely intact with some news readers. In the future, copy or
restate relevant information from the subject line into the body of the
posting.


For example: I want 17.9 % to round to .18

Since percentage is simply an operator and a format, you need to think of
the rounding precision in terms of the actual value. 17.9% is really the
value 0.179. So you want ROUND(...,2).

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.

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.

Thank you very much.

"Luke M" wrote:

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.

1) You should stay with one thread and one newsgroup

2) You keep jumping from % to fraction. Percent is just a way to DISPLAY so
let's talk using real numbers. You want 0.179 to round to 0.18 so use
=ROUND(B12/$B$10,2) to round it to 2 decimal places and then format as %
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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.

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.

Must be the number ,2. Thanks

"Bob Phillips" wrote:

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.