how do I get excel 2003 to round up

[Guest]

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(B3>0,(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?

 

[Celtic_Avenger]

Try the following

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


Celtic_Avenge

 

[Myrna Larson]

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(B3>0,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.