+ Reply to Thread
Results 1 to 4 of 4

Excel formula/function brainstorming

  1. #1
    Registered User
    Join Date
    08-23-2016
    Location
    Australia
    MS-Off Ver
    Home and student 2016
    Posts
    2

    Excel formula/function brainstorming

    Hi everybody,
    My name is Manu and i am carpenter, i am looking for one formula/function that could help me find the quantity of one item that i need to achieve the realization of different length of a smaller item.
    In number will be more clear : for example, i need to chop 8 pieces of wood, each measuring 1.8m, in a beam of 5m. How can i find out how many 5m beam i will need to do the job ?
    Is there any function that keep the entire value of a calculated number ? (ex: 5/1.8=2.777 i would like to keep only the 2 without decimal value)
    Thanks a lot for your help, i hope i am not posting on a subject already discussed.
    Manu

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Excel formula/function brainstorming

    Try this. It will return 2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Excel formula/function brainstorming

    That can be accomplished using the INT function - it returns the INTeger value of a result, so you can do this:

    =INT(5/1.8)

    to return 2.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    08-23-2016
    Location
    Australia
    MS-Off Ver
    Home and student 2016
    Posts
    2

    Re: Excel formula/function brainstorming

    Awesome, i think that will be enough to get it done Thank you soo much.

+ 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. What is the excel function for this formula?
    By lolyayman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2014, 01:27 AM
  2. Replies: 1
    Last Post: 02-06-2014, 09:22 AM
  3. Excel Help/Calendar...
    By jacksontho in forum Excel General
    Replies: 1
    Last Post: 07-24-2013, 02:18 AM
  4. Excel Formula or Function Help Please
    By mystworlds in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-25-2013, 06:34 AM
  5. Need Excel formula in Macro using Subtotal formula with If function
    By mbnewton1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2013, 03:00 PM
  6. [SOLVED] Excel Formula HELP - IF Function
    By BROWNANDBLUE in forum Excel General
    Replies: 8
    Last Post: 07-17-2012, 01:00 PM
  7. Brainstorming ways to insert online data into spreadsheet
    By va1damar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2006, 11:11 AM
  8. Brainstorming possible file errors/problems
    By Nick Hebb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2005, 08:05 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