+ Reply to Thread
Results 1 to 3 of 3

Formula Help: IF/THEN that provides whole number rounded to a given unit of measure

Hybrid View

new2purchasing Formula Help: IF/THEN that... 05-07-2014, 10:01 AM
TPDave Re: Formula Help: IF/THEN... 05-07-2014, 10:04 AM
new2purchasing Re: Formula Help: IF/THEN... 05-07-2014, 10:25 AM
  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    TX, USA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Formula Help: IF/THEN that provides whole number rounded to a given unit of measure

    I am looking for help to come up with a formula that provides a result rounded to a given unit of measure.

    My duties are to continually analyze the MIN/MAX of what is now 5000 line items (and growing). I am having to manually come up with the result that I am trying to find an equation for. Sure hope someone can help!

    Specifics:
    COLUMN AJ - the buy unit of measure in which I have to buy a given product
    COLUMN AI - where I am currently entering a manual number, and where I hope to use an equation
    COLUMN AH - titled MAX CALC - this is an output column that shows how many I need to have on hand based on another calculation. It can change based on a change in lead time and/or change in the number of safety stock days I want.

    A few actuals:

    equation help sample.PNG


    So the examples should show all scenarios; where AH is zero, less than the buy unit, more than the buy unit, equal to the buy unit. If there are any questions, please let me know. This is the first time I'm posting in this forum, and my second forum post ever!

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Formula Help: IF/THEN that provides whole number rounded to a given unit of measure

    Please upload a workbook, this isn't too difficult so should be a quick fix. Thanks

  3. #3
    Registered User
    Join Date
    05-07-2014
    Location
    TX, USA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Formula Help: IF/THEN that provides whole number rounded to a given unit of measure

    Appreciate the help, TPDave.
    Attached Files Attached Files

+ 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. Inventory Unit of Measure Calculations VBA in EXCEL_Unsolved
    By AGCSC1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 01:44 PM
  2. [SOLVED] Unit of Measure Calculations Backward & Forwards_ Excel VBA Programming
    By AGCSC1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2013, 10:03 AM
  3. Finishing touch: converting quantities to reflect unit of measure
    By SFranc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-17-2012, 05:25 PM
  4. Changing measure unit of culomns and rows
    By marianmix in forum Excel General
    Replies: 2
    Last Post: 03-06-2011, 06:21 PM
  5. Auto insert Unit of Measure
    By FS_Blues in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 04:50 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