I want to take a dollar amount and round it up to the nearest nickel.
D Dave Peterson Mar 15, 2007 #2 =ceiling(a1,.05) is one way. I want to take a dollar amount and round it up to the nearest nickel. Click to expand...
=ceiling(a1,.05) is one way. I want to take a dollar amount and round it up to the nearest nickel. Click to expand...
