I have a long list of £ prices. I want to round anything under £10.00 to the
nearest 10p (easy) I want to round anything over £50 to the nearest £1 (easy
again) but I need to round anything £10 and <£50 to the nearest (up or
down) to the nearest £0.50p.

Any Ideas? I've tried mROUND but can't get it to work!

Thanks in advance.

G