how do I round up to the nearest nickel?

Melanie · Mar 15, 2007

I want to take a dollar amount and round it up to the nearest nickel.

Dave Peterson · Mar 15, 2007

=ceiling(a1,.05)

is one way.

I want to take a dollar amount and round it up to the nearest nickel.

Teethless mama · Mar 15, 2007

=ROUNDUP(A1/0.05,0)*0.05

How do I get a calculated amount to round to the nearest nickel?	3	Jul 24, 2007
Size & Position precision	0	May 14, 2021
rounding numbers to the nearest dollar amount	11	Apr 6, 2009
rounding a number up to a certain ending digit	6	May 4, 2012
Rounding Time to Nearest 5 Minutes	1	Mar 2, 2011
Can I round to the nearest nickel@	2	Aug 5, 2004
rounding up to the nearest 1000	1	Feb 23, 2010
multiple ranges, transposing?	17	Oct 30, 2008

Ask a Question