>=ROUND(A1/0.05,0)*0.05
Slightly shorter
=mround(a1,0.05) for analysis tool pack
note not exactly what OP asked for as 0.38 gives 0.40 not ending in 5
cheers RES
>=ROUND(A1/0.05,0)*0.05
Slightly shorter
=mround(a1,0.05) for analysis tool pack
note not exactly what OP asked for as 0.38 gives 0.40 not ending in 5
cheers RES
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks