Results 1 to 6 of 6

Stock advisory based on three variables; urgent, advice, not needed

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2017
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    19

    Stock advisory based on three variables; urgent, advice, not needed

    I think its quite simple when you know which formulas to use, im not too sure.

    I have three columns, minimum stock, maximum stock, actual stock.

    If Actual Stock is SAME or SMALLER than Minimum Stock; it should say Urgent
    If Actual Stock is LOWER than Maximum Stock but GREATER than Minimum Stock it should say; Advice
    If Actual Stock is SAME or GREATER than Maximum Stock; it should say Not needed.

    If you require more columns to show True and False, and then in a third column have it say urgent, advice, or not needed, based on true;true, true;false, false;false, i will accept that as well.
    (That what i almost had functioning.)

    In the attachement i made a small setup.

    thank you all for having a look, but more; advice and actual help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-02-2017, 12:29 PM
  2. Replies: 0
    Last Post: 04-08-2015, 04:40 PM
  3. Urgent help needed changing values based on check boxes
    By Skinnybob in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2014, 11:10 AM
  4. [SOLVED] Formula Needed To Count Then Sum Based off Two Variables (EXCEL EXAMPLE ATTCHED)
    By Mustangs in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-06-2014, 02:32 PM
  5. Urgent help for pop up alert on stock control
    By Gunner_gav in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-18-2013, 02:32 PM
  6. Need some advice in Boolean variables
    By Jdash99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2010, 11:24 AM
  7. [SOLVED] advice needed
    By Duncan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 07:06 PM

Tags for this Thread

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