Results 1 to 3 of 3

0 Value Cell Formula to create 0 values in other cells that have references formulas.

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    10

    0 Value Cell Formula to create 0 values in other cells that have references formulas.

    I am trying to create a formula(s) that will only allow a value in other connected cells when the value of the 1st cell is zero. In the example that I have if there is a zero value in F6 (Sheet - "Invoice") I don't want there to be any values in cells F7 thre F13 even though those cells reference other cell values or formulas. I only want those to show up when there is a value of 1 or more in F6.

    Is this possible?

    I will be doing this on column G thru M also.

    Rick

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  2. Replies: 1
    Last Post: 03-22-2012, 01:28 PM
  3. Replies: 1
    Last Post: 06-08-2009, 08:54 AM
  4. Write values of the formulas in to the cells instead of using formula in the cell
    By kgc400 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2009, 10:59 AM
  5. Replies: 5
    Last Post: 04-26-2005, 06: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