View Single Post
  #1   Report Post  
eric p
 
Posts: n/a
Default How can set how a number rounds up in excel

I have the folling formula =IF(B2<=0," ",IF(B20,B2*1.5%)) I want excel to
round up the results if there are more than 2 digits after the decimal point
example 8.011 becomes 8.01 what do I need to add to this formula to do that?