Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 12:19 AM
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  
Old October 28th 04, 02:59 AM
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
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 08:49 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04: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 05:54 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017