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

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

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 :-)
------------------------------*------------------------------*----------------


"Tim" wrote in message
...
How do I round to the nearest $5.00 in Excel? $74.03=$75

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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506589