View Single Post
  #1   Report Post  
eric p
 
Posts: n/a
Default how do I get excel 2003 to round up

i have the following formula but i need the results to round up if there are
3 digits after the decimal point =IF(B3<=0," ",IF(B30,(D2+B3)*1.5%))
excample 8.011 would become 8.02 what do i need to add to this formula to
make it do that?