Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Rounding down a figure in Excel

  • 09-07-2009 6:37pm
    #1
    kleefarr
    Registered Users, Registered Users 2 Posts: 5,744 ✭✭✭


    I have a 'sum' placed in a cell in Excel which shows the VAT figure when the other prices have been input. But I'm trying to get that figure Rounded down to the nearest €.

    I have - '=SUM(I45:I50)*21.5%'

    and have tried '=SUM(I45:I50)*21.5%,rounddown(number,0) which it seems to be telling me is the solution, but it's not working.

    Any ideas guys?


Comments

  • #2
    Random
    Closed Accounts Posts: 19,080 ✭✭✭✭Random


    Would it not be

    =rounddown(FORMULA,0)

    and that's it?


  • #3
    Random
    Closed Accounts Posts: 19,080 ✭✭✭✭Random


    Err.. this

    =ROUNDDOWN(SUM(I45:I50)*21.5%,0)


  • #4
    tman
    Closed Accounts Posts: 16,339 ✭✭✭✭tman


    Or you could select the cells, right click > format cells > number > decimal places = 0

    /edit
    sorry, that rounds up or down to the nearest number, not just down...


  • #5
    kleefarr
    Registered Users, Registered Users 2 Posts: 5,744 ✭✭✭kleefarr


    Random wrote: »
    Err.. this

    =ROUNDDOWN(SUM(I45:I50)*21.5%,0)

    That seems to work. Thanks Random. :)

    VAT does get rounded down to the nearest € doesn't it?


  • #6
    Random
    Closed Accounts Posts: 19,080 ✭✭✭✭Random


    Ah now .. come on Ted .. don't be asking difficult questions !


  • Advertisement
  • #7
    kleefarr
    Registered Users, Registered Users 2 Posts: 5,744 ✭✭✭kleefarr


    lol..

    I have just checked an invoice I received and the VAT wasn't rounded down, so I guess not.

    May as well scrap that formula then. :(

    Thanks anyway. :o


  • #8
    Random
    Closed Accounts Posts: 19,080 ✭✭✭✭Random


    When invoicing you for my wasted time would you like the figure rounded up or down? ;)


  • #9
    kleefarr
    Registered Users, Registered Users 2 Posts: 5,744 ✭✭✭kleefarr


    Yeah, down please. Sorry.

    May come in helpful for future use of other boardsies. ;)


  • #10
    Hagar
    Closed Accounts Posts: 16,793 ✭✭✭✭Hagar


    God bless your innocence if you think that any tax is rounded down.


  • #11
    kleefarr
    Registered Users, Registered Users 2 Posts: 5,744 ✭✭✭kleefarr


    Yeah, guess it was a bit of wishful thinking. :o


  • Advertisement
  • #12
    jcbh
    Registered Users, Registered Users 2 Posts: 13 ✭jcbh


    You can round down VAT. I do it all the time and have done so for years without any problems. :)


Advertisement