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

First thought, not necessarily correct. Multiply the amount by 2, round to
the nearest £1 then divide by 2.

--
Ian
--
"Graham Aird" wrote in message
...
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

Sounds good, any help on the formular?

It currently stands at!

if(l38<10,round(l38,1)if(l3810<50,mround(l38,0.5) ,if(l3850,round(l38,-1),L38)))

You might have and easy way for it all!

Thanks

"Ian" wrote:

First thought, not necessarily correct. Multiply the amount by 2, round to
the nearest £1 then divide by 2.

--
Ian
--
"Graham Aird" wrote in message
...
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

Try

=IF(A1<10,ROUND(A1,1),IF(A1<50,ROUND(A1*2,0)/2,ROUND(A1,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Graham Aird" wrote in message
...
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

Fantastic. Thanks for your speed response.

Good Health to you

"Bob Phillips" wrote:

Try

=IF(A1<10,ROUND(A1,1),IF(A1<50,ROUND(A1*2,0)/2,ROUND(A1,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Graham Aird" wrote in message
...
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