Results 1 to 7 of 7

Thread: Issue with zero in a formula

  1. #1

    Issue with zero in a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a formula listed below that occasionally comes up with a zero number in b333 cell:

    =SUM(((D282*B332)*B333*B334)-B307)

    When it does come up I want to have the formula ignore it and move to the next calculation. How can I do this ?

    Ta Polly

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Try below formula:

    =IF(B333=0,"",SUM(((D282*B332)*B333*B334)-B307))

  3. #3
    Quote Originally Posted by sambit View Post
    Hi,
    Try below formula:

    =IF(B333=0,"",SUM(((D282*B332)*B333*B334)-B307))
    Thanks for that but now I don't get an answer when there is a zero in b333. What I need is for that calculation *b333 to be ignored if it has a zero in it and move to the next calculation *b334.

    Example:

    (d282) * (b332) * b333 * b334 - b307
    100 * 0.71 * 0 IGNORE * 0.26 - 4 = 12.46 SHOULD BE THE ANSWER

    Ta Darren

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Try:
    =IF(B333=0,SUM(((D282*B332)*B334)-B307),SUM(((D282*B332)*B333*B334)-B307))

  5. #5
    Works beautifully thank you for that.

    Ta Polly

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,721
    Articles
    0
    Excel Version
    2010 on Xubuntu
    FYI the SUM function is unnecessary in your formula =IF(B333=0,((D282*B332*B334)-B307),((D282*B332*B333*B334)-B307))

  7. #7
    It's what I was looking for
    Quote Originally Posted by Pecoflyer View Post
    FYI the SUM function is unnecessary in your formula =IF(B333=0,((D282*B332*B334)-B307),((D282*B332*B333*B334)-B307))

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •