+ Reply to Thread
Results 1 to 2 of 2

formula that doesn't include 0 values

  1. 12-06-2013, 02:53 PM #1
    amartino44
    amartino44 is offline
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    formula that doesn't include 0 values

    Hello. I'm calculating a variance for a set of actual numbers vs. variance numbers. When there are no actuals, I don't want the formula to calculate a variance. How can I do this? Spreadsheet attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-06-2013, 03:09 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: formula that doesn't include 0 values

    Try this:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    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)

Similar Threads

  1. [SOLVED] Formula to dynamically include one or more values from preceding row(s)
    By linksavage in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2012, 07:54 PM
  2. [SOLVED] IF formula to include 3 possible values
    By degendorfer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-06-2012, 07:30 PM
  3. Consolidating Rows Doesn't Include Negative Values
    By aferoz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 11:07 AM
  4. [SOLVED] Insert function - doesn't include all functions??
    By Hall in forum Excel General
    Replies: 4
    Last Post: 03-24-2006, 03:30 PM
  5. [SOLVED] AutoSum macro that doesn't include headings
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1