Remember Me?

#1
October 28th 04, 12:19 AM
 eric p Posts: n/a
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?

#2
October 28th 04, 02:59 AM
 Celtic_Avenger Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ronmjo Excel Discussion (Misc queries) 3 January 18th 05 08:49 PM [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 05:54 PM

All times are GMT +1. The time now is 08:16 AM.