View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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.