How can set how a number rounds up in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the folling formula =IF(B2<=0," ",IF(B2>0,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?
 
Please see other post.

Please try not to multi post the same question.

But I replied to other post with:

Try the following

=IF(B3<=0," ",IF(B3>0,(ROUNDUP((D2+B3)*1.5%,2))))


Celtic_Avenge
 
Back
Top