Results 1 to 7 of 7

Help with IFERROR Formula blanks

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2015
    Location
    Florida, US
    MS-Off Ver
    2013
    Posts
    33

    Help with IFERROR Formula blanks

    Hey guys i was wondering if you could help me with the formulas in column G and Column I of the included sample sheet.

    What i want to do is if there is no date in the "Promise Date" column (D) then i want it to be blank unless there is a date in the "Ship Date" column (E) in which case i want it to show "Not Promised". This is to avoid it showing Not Promised when the cell is not populated which is what it is doing now. There are other criteria in play as well but i can't add another without it giving me an error stating that im doing to many functions.

    I've added a few mockup dates so you can see the different things it is currently doing and what the other criteria do. This is all so that in columns M and N it calculates the percent on time for both the delivery and our promise.

    Thanks alot for your 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. [SOLVED] Multiple IFERROR or IFERROR w/ If Statements
    By SanchoPanza1 in forum Excel General
    Replies: 4
    Last Post: 03-31-2016, 08:09 PM
  2. [SOLVED] IFERROR(MATCH & IFERROR(SMALL Help Needed
    By chad328 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-17-2016, 06:34 AM
  3. Iferror or other formula
    By sarahqputra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2015, 07:31 AM
  4. [SOLVED] Use of IFERROR to include showing blanks when certain criteria is met
    By gruss in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 11:08 AM
  5. xlfn.IFERROR or IFERROR don't work in Excel 98-2003
    By dj_danu01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 02:53 AM
  6. IFERROR Formula HELP PLEASE
    By jonnykhan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2013, 09:52 AM
  7. [SOLVED] #DIV/0 IFERROR formula
    By rlkerr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 10:33 AM

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