Quick Excel Question/Help Pls

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

Join Australia's most dynamic and respected property investment community
  1. bonkerrs

    bonkerrs Active Member

    Joined:
    1st Jul, 2015
    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?
     
    bonkerrs, 26th Mar, 2009
    #1
  2. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,412
    Location:
    Sydney
    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.
     
    Simon Hampel, 26th Mar, 2009
    #2
  3. bonkerrs

    bonkerrs Active Member

    Joined:
    1st Jul, 2015
    Posts:
    25
    Location:
    Sydney NSW
    Beautiful! Just applied the round down maths function.
    Thanks (again) Sim!
     
    bonkerrs, 26th Mar, 2009
    #3
Buy Property Interstate WITHOUT Buyers Agents!

Buy Property Interstate WITHOUT Dropping $15k On Buyers Agents Each Time! Helping People Achieve PASSIVE INCOME Using Our Unique Data-Driven System, So You Can Confidently Buy Top 5% Growth & Cashflow Property, Anywhere In Australia