ExcelBanter - how do I round up to the nearest nickel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I round up to the nearest nickel? (https://www.excelbanter.com/excel-worksheet-functions/135039-how-do-i-round-up-nearest-nickel.html)

Melanie

how do I round up to the nearest nickel?

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

Dave Peterson

how do I round up to the nearest nickel?

=ceiling(a1,.05)

is one way.

Melanie wrote:

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

--

Dave Peterson

Teethless mama

how do I round up to the nearest nickel?

=ROUNDUP(A1/0.05,0)*0.05

"Melanie" wrote:

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

All times are GMT +1. The time now is 09:11 AM.