Remember Me?

#1
October 28th 04, 01:27 AM
 eric p Posts: n/a
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
October 28th 04, 02:56 AM
 Celtic_Avenger Posts: n/a

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

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

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?

 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 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM

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