Results 1 to 10 of 10

isblank inappropriate for more than 1 cell?

Threaded View

  1. 11-11-2014, 10:57 AM #1
    Butcher1
    Butcher1 is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    isblank inappropriate for more than 1 cell?

    In the attached worksheet I have this formula and other similar
    Formula: copy to clipboard 
    =IF(ISBLANK(C1:C10),"No Input",COUNTIF(C1:C10,1))


    If you start putting in values in column C the formula will not register the values until you end up in the same row as the formula. To see what exactly I mean, put a 1 in C1, then C2 and on and watch the formulas. What is a way around this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ISBLANK w/ Formula in target cell
    By grantpank in forum Excel General
    Replies: 2
    Last Post: 08-29-2011, 06:12 PM
  2. 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
  3. ISBLANK function and Cell range
    By AndyF19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 09:33 AM
  4. [SOLVED] differentiate between a ISBLANK and an actual empty cell?
    By all4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2007, 01:23 AM
  5. Can you test for a range (Q16:19) any cell is ISBLANK
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2005, 02:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1