Join our investing community

Quick Excel Question/Help Pls

Discussion in 'Accounting, Tax & Legal' started by bonkerrs, 26th Mar, 2009.

  1. bonkerrs

    bonkerrs Active Member

    Joined:
    26th Jul, 2007
    Posts:
    25
    Location:
    Sydney NSW
    Thought I'd ask here with the assumption there are Excel experts here! :D

    If I have '6.35' in a cell I can use 'format cell' and change the decimal place to nothing to show '6'.

    What I want is to show '6' even if the number is '6.78'. Anyone?
     
  2. Simon Hampel

    Simon Hampel Co-founder Staff Member

    Joined:
    9th Jun, 2005
    Posts:
    4,623
    Location:
    Sydney, Australia
    If you use format cell, the actual number stored in the cell doesn't change - only the way it is displayed. Hence if you use that cell in a calculation, Excel will use the real number, not the displayed number.

    If you want to actually round the number so the number stored is just an integer (no decimal places), use either ROUND, ROUNDUP or ROUNDDOWN functions with num_digits set to 0. Alternatively the INT function rounds a number down to the nearest integer.

    Note that ROUNDDOWN and INT behave slightly differently for negative numbers.
     
  3. bonkerrs

    bonkerrs Active Member

    Joined:
    26th Jul, 2007
    Posts:
    25
    Location:
    Sydney NSW
    Beautiful! Just applied the round down maths function.
    Thanks (again) Sim!