Groups

    Excel Techy Question

    Need a formulae in excel to do the following.

    I have 50,000 principle values than need to be rounded down to £0.50.

    Example:
    £12.21 would = £12.00
    £202.76 would = £202.50
    £1007.49 would = £1007.00

    Any help much appreciated

    8 Comments

    gemz700;2634838

    this might … this might helphttp://www.viloria.com/secondthoughts/archives/00000775.html



    not quite right needs to be:

    =FLOOR(A1,0.5)

    drag the formula down and then change to currency with 2 decimal places

    Banned

    king261;2634960

    not quite right needs to be:=FLOOR(A1,0.5) drag the formula down and then … not quite right needs to be:=FLOOR(A1,0.5) drag the formula down and then change to currency with 2 decimal places



    Yeah that works. It would also be possible to rounding to the nearest 50p if needed

    Shouldn't your last answer be £1007.00

    Jumpingphil;2635941

    Shouldn't your last answer be £1007.00



    no coz its to the nearest 50p

    TWIGGY4LIFE 666;2635973

    no coz its to the nearest 50p



    It's rounded down to the nearest 50p so the answer ends in 0 or 50p.


    If its to the nearest 50p then it would be £1007.50.

    Original Poster

    Sorry everyone.. my requirement is down to 0.50p... so the answer should have been 1007.00

    Think i've managed to crack it now.. although for some reason my formula is alot beigger than these lol.

    Many Thanks
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Sad Gazza anecdote August 8th 2017 - Beyond help?1219
      2. How dangerous is Donald trump?28128
      3. What are you loving on the BBC at the moment?63218
      4. Can't delete friends on Xbox 360 or accept any friend requests, anyone know…33

      See more discussions