ExcelBanter - How can set how a number rounds up in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can set how a number rounds up in excel (https://www.excelbanter.com/excel-worksheet-functions/5165-how-can-set-how-number-rounds-up-excel.html)

eric p

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?

Celtic_Avenger

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(B30,(ROUNDUP((D2+B3)*1.5%,2))))

Celtic_Avenger

--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...o&userid=14101
View this thread: http://www.excelforum.com/showthread...hreadid=273026

All times are GMT +1. The time now is 11:20 PM.