Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 01:27 AM
eric p
 
Posts: n/a
Default how do I get excel 2003 to round up

i have the following formula but i need the results to round up if there are
3 digits after the decimal point =IF(B3<=0," ",IF(B30,(D2+B3)*1.5%))
excample 8.011 would become 8.02 what do i need to add to this formula to
make it do that?

  #2   Report Post  
Old October 28th 04, 02:56 AM
Celtic_Avenger
 
Posts: n/a
Default


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=273038

  #3   Report Post  
Old October 28th 04, 04:30 AM
Myrna Larson
 
Posts: n/a
Default

Guess what! With a function named ROUNDUP. But you don't need a 2nd IF
statement. If B3 is not <=0, it must be 0.

=IF(B3<=0,"",ROUNDUP((D2+B3)*1.5%,2))

Or:

=IF(B30,ROUNDUP((D2+B3)*1.5%,2),"")

Check it out in Help if you need more information. Notice that I removed the
space between your quote marks, too.


On Wed, 27 Oct 2004 17:27:01 -0700, eric p
wrote:

i have the following formula but i need the results to round up if there are
3 digits after the decimal point =IF(B3<=0," ",IF(B30,(D2+B3)*1.5%))
excample 8.011 would become 8.02 what do i need to add to this formula to
make it do that?




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
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 05:02 PM.

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