Results 1 to 3 of 3

Thread: If Not blank - Formula for two cells

  1. 2013-03-15, 05:53 PM #1
    INMD13
    INMD13 is offline
    Seeker INMD13's Avatar
    Join Date
    Mar 2013
    Posts
    6
    Articles
    0
    Excel Version
    Mac Version 16.21.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.
    Reply With Quote Reply With Quote
  2. 2013-03-15, 07:44 PM #2
    NBVC
    NBVC is offline
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    =IF(OR(A1<>"",B1<>""),1,0)

    or

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

    Reply With Quote Reply With Quote
  3. 2013-03-21, 03:32 AM #3
    INMD13
    INMD13 is offline
    Seeker INMD13's Avatar
    Join Date
    Mar 2013
    Posts
    6
    Articles
    0
    Excel Version
    Mac Version 16.21.1

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

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

Gravatar by 1e2.it