software

How do I round to the nearest $5.00 in Excel? $74.03=$75

=CEILING(A1,5)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Timquot; gt; wrote in message
...
gt; How do I round to the nearest $5.00 in Excel? $74.03=$75

To round to the nearest $5

=MROUND(A1,5)

MROUND is part of Analysis ToolPak

an alternative is

=ROUND(A1/5,0)*5--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506589