Help! I have a massive pricing update I need to put together rather
quickly.
I'm using the Roundup function in excel and I need dollar values to be
rounded up to the nearest nickel. IE- $3.73 will become $3.75, 3.78
would become 3.80, etc.

I can not seem to figure this out. The closest I can get is making a
number round up to the nearest dime, but can not seem to get it to
round up to the nearest nickel.

Any help would be greatly appreciated. Thanks,
Jeff


--
jhangas
------------------------------------------------------------------------
jhangas's Profile: http://www.excelforum.com/member.php...o&userid=23814
View this thread: http://www.excelforum.com/showthread...hreadid=374703