I was being pedantic Bernd <g. Following the actual logic of the process.
Need to step back.

I think your second version is the best, it easily translates to other
thresholds.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hello Bob,

Shorter :-)

=ROUND(A1*2,1)/2

or

=ROUND(A1/5,2)*5

Have fun,
Bernd