Rounding up to the nearest nickel
 

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

if the value is in cell b2, in c2 you can use
=CEILING(B2,0.05)


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

one way:

=CEILING(A1, 0.05)


In article ,
jhangas wrote:

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

guys, this is excellent info and I'm now rolling. Thanks!


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