Re: Rounding

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" <GrahamAird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B701C9E9-CFDF-4A00-9B82-2BEC56819ECF@xxxxxxxxxxxxxxxx
> 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
>
>
>
>


.

Relevant Pages

  • Re: Rounding
    ... >I have a long list of £ prices. ... I want to round anything under £10.00 to ... > down) to the nearest £0.50p. ...
    (microsoft.public.excel.misc)
  • with regard to Norriss advanced fresh product
    ... round the ordinary opera. ... Abduljalil starts the appropriate wildlife very actively? ... The prices, habits, and bicycles are all ... Anybody wickedly lower as usual Imran when the common lots emphasise ...
    (sci.crypt)
  • Re: Changing the colour if given condition occurs
    ... Once prices have been copied into ... I click on the ROUND button and these NEW prices move ... companies are just names that do not appear in any database. ... and explain what the "heading" is (since Heading is not an Access ...
    (microsoft.public.access.gettingstarted)
  • Re: Changing the colour if given condition occurs
    ... "Jeff Boyce" wrote: ... ROUNDS and see the previous prices of stocks. ... I click on the ROUND button and these NEW prices ...
    (microsoft.public.access.gettingstarted)
  • Re: Changing the colour if given condition occurs
    ... where it's saving the values. ... ROUNDS and see the previous prices of stocks. ... I click on the ROUND button and these NEW prices ...
    (microsoft.public.access.gettingstarted)