1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Round up help in excel.

Discussion in 'Business Applications' started by quiff, Feb 16, 2015.

Thread Status:
Not open for further replies.
Advertisement
  1. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    I am looking for some help with excel. I want to round a number up all the time.


    Basically;


    In Cell A1 I will be entering different number values.


    In cell A2 I have the formula =(A1/350)+2


    Now the problem I have is sometimes the number I get in cell A2 has a decimal place i.e, 7.37. However I want that number always rounded up so there are no decimal places. i.e, if 7.37 round up to 8, if 35.11 round up to 36.


    Is there anyway to make this happen, once again I appreciate all help.


    Thanks


    Quiff
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,127
    First Name:
    Chuck
  3. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    Yeah that sorted it.


    Thanks
     
  4. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,127
    First Name:
    Chuck
    You're welcome.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Round help
  1. FernJones
    Replies:
    3
    Views:
    342
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1143192

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice