Results 1 to 16 of 16

NULL (blank) problem

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    Dallas, TC
    MS-Off Ver
    Excel 2007
    Posts
    30

    NULL (blank) problem

    Hello everyone;
    In the attached spreadsheet, Row-3 gets it values from Row-2 (it's a cumulative total). I need some assistance for a formula statement like this;

    If F2, G2....is NULL, then F3,G3....is also NULL
    If F2, G2...is a number (including 0), then continue with cumulative total.

    Note that row-2 is manually entered. Row 3 relies on row-2 to continue with its total.

    Can this be done? Will appreciate any help folks!

    Thanks
    Attached Files Attached Files
    Last edited by amt7565; 02-08-2014 at 09:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make 0 Value Cells = Blank / Null
    By jboyd12 in forum Excel General
    Replies: 7
    Last Post: 07-10-2012, 12:57 PM
  2. Replies: 1
    Last Post: 11-13-2011, 04:03 AM
  3. Blank cells are getting populated as null
    By Banerjee in forum Excel General
    Replies: 1
    Last Post: 05-29-2009, 04:51 AM
  4. Blank Cells But Not Null Values
    By jtwork in forum Excel General
    Replies: 1
    Last Post: 04-17-2007, 08:08 AM
  5. How to set cell value to null/blank
    By Tallukka in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-18-2005, 12:28 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