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