Results 1 to 5 of 5

ISBLANK formula error

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Salt Lake City, UT
    MS-Off Ver
    Professional Plus 2013
    Posts
    54

    ISBLANK formula error

    I'm trying to use ISBLANK in this formula:

    =IF(OR(ISBLANK(P),(LOOKUP(DATEDIF(K3,N3,"m"),{0,2,3},{"On Time","In Progress","Delayed"}),(ISBLANK(N),"")))))))

    I want column P to have the formula based on whether there is data in column N. I keep coming back with an error. Any advice?
    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] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 02:37 PM
  2. [SOLVED] if isblank error message
    By gocolonel77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2013, 01:25 PM
  3. [SOLVED] Using If and isblank and Left text error
    By bigash17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2013, 06:31 PM
  4. Isblank help and formula error
    By afountas21 in forum Excel General
    Replies: 1
    Last Post: 09-14-2012, 12:24 PM
  5. [SOLVED] IF ISBLANK Error in Formula
    By lday75 in forum Excel General
    Replies: 2
    Last Post: 09-03-2012, 08:44 AM
  6. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  7. error message ISBLANK
    By Hans in forum Excel General
    Replies: 4
    Last Post: 01-12-2005, 12:06 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