View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SunshineinFt.Myers[_2_] SunshineinFt.Myers[_2_] is offline
external usenet poster
 
Posts: 14
Default ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH

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.