Results 1 to 3 of 3

Thread: If Not blank - Formula for two cells

  1. #1

    If Not blank - Formula for two cells



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

    Hi All,

    I was wondering how I can write write the following formula. I want the formula to return a "1" if either cell A1 or B1 is NOT blank,otherwise retunr "0".

    IT would look something like this

    IF(NOT(ISBLANK(A1, B1)), 1, 0) <- This is not working for me.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,477
    Articles
    0
    Excel Version
    Excel 2016
    =IF(OR(A1<>"",B1<>""),1,0)

    or

    =(OR(A1<>"",B1<>"") )+0


  3. #3

    Thanks!!!

    Great! This worked perfectly thank you so much


    Quote Originally Posted by NBVC View Post
    =IF(OR(A1<>"",B1<>""),1,0)

    or

    =(OR(A1<>"",B1<>"") )+0

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
  •