+ Reply to Thread
Results 1 to 8 of 8

trying to calculate a formula to round of a item to a specific figure

  1. #1
    Registered User
    Join Date
    03-17-2016
    Location
    australia
    MS-Off Ver
    10
    Posts
    14

    trying to calculate a formula to round of a item to a specific figure

    hey all,
    I am trying to make a sum
    and example is if I have a 3m gate I would need 2 tracks but if its greater then 3m I would need 4 each track is 3m long so if the gate is 4.5m long I would need 3 tracks
    what I want is to put the size of the gate in and it to calculate how many tracks but I am lost to figure it out
    thanks in advance.
    Last edited by phatty; 10-21-2020 at 01:59 AM. Reason: I am a naughty little boy

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: not sure on formula

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-17-2016
    Location
    australia
    MS-Off Ver
    10
    Posts
    14

    Re: not sure on formula

    sorry Ford I have amended it to what I think I am trying to do

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: trying to calculate a formula to round of a item to a specific figure

    Thank You for changing the title.
    As to "if I have a 3m gate I would need 2 tracks but if its greater then 3m I would need 4 each track is 3m long so if the gate is 4.5m long I would need 3 tracks", it seems contradictory as 4.5m is longer than 3m so it would seem there would need to be 4 tracks and not 3.
    For 4 tracks is correct then try: =IF(A1<=3,2,4)
    Note that the length would be in cell A1.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    03-17-2016
    Location
    australia
    MS-Off Ver
    10
    Posts
    14

    Re: trying to calculate a formula to round of a item to a specific figure

    thanks for your reply Jete,
    sorry i reread what i wrote and see my mistake.
    so 3m gate would be 2 tracks
    over 3m gate would be 3 track
    4.5m gate would be 3 tracks
    over 4.5m gate would be 4 tracks
    I think i will play with your exuations and see if i can make something work I asume i would need something like this =IF(A1<=3,2,3,A1<=4.5,4)
    now to work out how to make the formula run as t

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: trying to calculate a formula to round of a item to a specific figure

    I believe that the following will yield the expected results: =ROUNDUP(A1/1.5,0)
    This assumes that the gate length is in cell A1.
    Let us know if you have any questions.

  7. #7
    Registered User
    Join Date
    03-17-2016
    Location
    australia
    MS-Off Ver
    10
    Posts
    14

    Re: trying to calculate a formula to round of a item to a specific figure

    omg thanks Jete your a champion

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: trying to calculate a formula to round of a item to a specific figure

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1