I have a second question - if I need to round either up or down,
depending on how the original dollar value divides, is there another
formula for this? I tried both th emround and round, and it seems as if
it always rounds up to the next .05. Thanks!


--
puppypants
------------------------------------------------------------------------
puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654
View this thread: http://www.excelforum.com/showthread...hreadid=483554