+ Reply to Thread
Results 1 to 3 of 3

How to keep cell blank till cell to left is populated?

Hybrid View

  1. 01-09-2011, 12:46 PM #1
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    How to keep cell blank till cell to left is populated?

    So I have this very simpe sheet ... See attached

    How do I keep cell C7 thru C17 blank untill the respective cell imediate to the left Cell B7 thru B17 is populated?

    Thanks in advance.
    Last edited by SVTF; 01-09-2011 at 01:24 PM.
    Reply With QuoteRegister To Reply
  2. 01-09-2011, 12:53 PM #2
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: How to keep cell blank till cell to left is populated?

    Hi,

    I like to use the ISBLANK function nested with an IF statement. In C7 put the formula:

    =IF(ISBLANK(B7),"",C6-B7)
    Others may have better ideas.

    Good luck.

    Abousetta
    Reply With QuoteRegister To Reply
  3. 01-09-2011, 01:24 PM #3
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: How to keep cell blank till cell to left is populated?

    Works fine.

    Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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