Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?
  #2   Report Post  
Celtic_Avenger
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do i set up excel to copy from one cell to a given number of . ronmjo Excel Discussion (Misc queries) 3 January 18th 05 09:49 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 06:54 PM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"