Thread: Rounding
View Single Post
  #2   Report Post  
Greg
 
Posts: n/a
Default

DR,

Try {=round(X,-2)} where X is the formula (e.g., {=round(1030,-2)}
would round to 1000 {=round(1051,-2)} would round to 1100
To hide the gridline, press TableHide Gridlines