Results 1 to 9 of 9

Ifand, ifor, or just if with networkdays??

Threaded View

  1. #6
    Registered User
    Join Date
    03-13-2023
    Location
    Mankato, MN, USA
    MS-Off Ver
    MS Office 2021
    Posts
    31

    Re: Ifand, ifor, or just if with networkdays??

    Sorry for the confusion.

    I need to know for each division if the order is under 999 units, the oldest order date.
    If there is no order for that division in the list, I need it to say "Current".
    Same scenario for orders over 1000 units

    Next, for the days behind, I need it to show "Current" if the order is within the 2 day turn time goal.
    If it is past that timeframe, I need the days behind the order is.

    Make sense?
    EXAMPLE 2.23.24.xlsx
    Last edited by dschwichtenberg; 02-23-2024 at 02:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IFAND Formula?
    By dschwichtenberg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2024, 03:35 AM
  2. [SOLVED] IFOR formula Help Please
    By Curtis2145 in forum Excel General
    Replies: 3
    Last Post: 09-26-2019, 12:08 PM
  3. [SOLVED] Nested IF / IFS / IFOR function
    By jyadayada in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2017, 11:47 AM
  4. Weighted Averages ifor values without returning Error of #DIV/0
    By meecheeda in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-08-2014, 07:12 PM
  5. IfAND = X But If Than
    By rwmeis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2013, 11:02 AM
  6. [SOLVED] Using IFAND Statements
    By hettbarn in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-15-2012, 11:36 AM
  7. [SOLVED] Q about: IfAnd or is it AndIf?
    By Michael Saffer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2006, 11:25 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