ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH

[SunshineinFt.Myers]

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.

 

[joeu2004]

:
[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).

 

[Bob Phillips]

That rounds to .18 for me, what do you get?

 

[Luke M]

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%

 

[Bernard Liengme]

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

 

[Bob Phillips]

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

 

[SunshineinFt.Myers]

Thank you very much.

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]

Must be the number ,2. Thanks

That rounds to .18 for me, what do you get?

--
__________________________________
HTH

Bob