+ Reply to Thread
Results 1 to 3 of 3

Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

  1. #1
    Forum Contributor
    Join Date
    08-15-2005
    Location
    Oklahoma
    MS-Off Ver
    2010, 2013
    Posts
    112

    Smile Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

    How would I modify the following statement to post a zero (0) in the cell when C78 = 0?

    =IFERROR(SUM(C77^$C$6*(C77^(1-$C$6)-C78^(1-$C$6))/(D78*(1-$C$6))),"0")
    Last edited by Jim15; 07-23-2013 at 05:38 PM.
    Jim15

  2. #2
    Registered User
    Join Date
    07-17-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

    The easiest way I see it working is test for that condition. If c78 = 0, then show 0, else do the calculation as desired.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    EDIT: If I could spell the world will be in sooo much trouble.

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

    Are you sure you want to quote that 0?

    Quoting numbers turns them into TEXT values which could lead to problems if you do other calculations on the result of this formula.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Modify Equation
    By alcharbonneau in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-24-2013, 08:50 PM
  2. [SOLVED] Modify Equation
    By alcharbonneau in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2013, 08:02 AM
  3. Sending a Nested IF Equation with Sheet References and an OR Statement to a Cell
    By itclonghorn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 06:43 PM
  4. Modify cell address within an IF statement
    By codyj1919 in forum Excel General
    Replies: 1
    Last Post: 12-20-2011, 05:30 PM
  5. Using Cell Values as Equation Variable
    By HodakMoment in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2007, 02:53 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