Results 1 to 5 of 5

Thread: How to "Do Not Display",

  1. #1

    How to "Do Not Display",



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

    Hi everybody,

    I have a formula in a cell that adds the value of two cells.

    Essentially, the formula is =SUM(A1+B1) and it is in cell C1

    The thing is, if either of the values of "A" and "B" are blank or null, I want the value of C1 to display a null.

    However, =IF(A1 .AND. B1="", "", SUM(A1+B1)) kinda chokes out excel 2003.

    How do I express an "IF" statement that needs to test two values?

    Many thanks,

    Paul

  2. #2
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    This should do the trick:
    =IF(AND(A1="",B1=""),"",A1+B1)

  3. #3
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    675
    Articles
    0
    Excel Version
    Excel 2010 64bit
    try this for either A1 or B1 blank or NULL

    =IF(OR(A1="",B1=""),"",A1+B1)

  4. #4
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    NoS, you're right, my formula isn't "either" .

  5. #5
    =if(count(a1:b1)>1,a1+b1,"")

Posting Permissions

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