How can set how a number rounds up in excel

's Computer Specifications

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?

's Computer Specifications

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

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27302

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
number automatically rounds up	=?Utf-8?B?S2hvc2hyYXZhbg==?=	Microsoft Access Getting Started	1	13th Aug 2007 07:12 AM
In excel, I paste from a table in Access the number format rounds	=?Utf-8?B?R2l6bW8uMTIz?=	Microsoft Access External Data	0	11th Aug 2005 07:21 PM
How can set how a number rounds up in excel	=?Utf-8?B?RWxwYmRjYg==?=	Microsoft Excel Worksheet Functions	1	26th Oct 2004 01:38 AM
Number field on form rounds off	=?Utf-8?B?am9l?=	Microsoft Access Database Table Design	2	9th Aug 2004 05:59 PM
format number rounds off	Tdiana	Microsoft Excel Discussion	1	9th Dec 2003 05:23 AM