Sorry, but I can't get this one to work for me.

When I posted my original question I mis-typed my function. This is a
corrected version.

=IF(ISERROR(MROUND(D2*0.5,0.01))," ",MROUND(D2*0.5,0.01))

Now assuming that D2 is $6897.75, my function results in $3448.88 which
is correct, but only works if D2 is a positve number.

=ROUND(D2*5,0)/100 yields $344.89




I tried =ROUND(D2*5,0)/10 but this tields $3448.90