+ Reply to Thread
Results 1 to 4 of 4

If Function for BLANK cells

  1. #1
    Andy
    Guest

    If Function for BLANK cells

    I have two columns, one of which row by row, may have blank cells in and
    other may have data.

    I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT NULL,
    then return a character.

    Probably some combination of If and AND statements, but can't get it to work.

    Help greatly appreciated as ever.

  2. #2
    Gary''s Student
    Guest

    RE: If Function for BLANK cells

    =IF(AND(A1="",B1<>""),"x","")
    --
    Gary''s Student


    "Andy" wrote:

    > I have two columns, one of which row by row, may have blank cells in and
    > other may have data.
    >
    > I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT NULL,
    > then return a character.
    >
    > Probably some combination of If and AND statements, but can't get it to work.
    >
    > Help greatly appreciated as ever.


  3. #3
    Roger Govier
    Guest

    Re: If Function for BLANK cells

    Hi Andy

    =IF(AND(A1="",B1<>""),"whatever_you_want","")

    --
    Regards

    Roger Govier


    "Andy" <Andy@discussions.microsoft.com> wrote in message
    news:E7A1AAF1-D9DC-4651-8589-66B875FAC700@microsoft.com...
    >I have two columns, one of which row by row, may have blank cells in
    >and
    > other may have data.
    >
    > I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT
    > NULL,
    > then return a character.
    >
    > Probably some combination of If and AND statements, but can't get it
    > to work.
    >
    > Help greatly appreciated as ever.




  4. #4
    Andy
    Guest

    Re: If Function for BLANK cells

    Spot on. Cheers everyone!

    "Roger Govier" wrote:

    > Hi Andy
    >
    > =IF(AND(A1="",B1<>""),"whatever_you_want","")
    >
    > --
    > Regards
    >
    > Roger Govier
    >
    >
    > "Andy" <Andy@discussions.microsoft.com> wrote in message
    > news:E7A1AAF1-D9DC-4651-8589-66B875FAC700@microsoft.com...
    > >I have two columns, one of which row by row, may have blank cells in
    > >and
    > > other may have data.
    > >
    > > I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT
    > > NULL,
    > > then return a character.
    > >
    > > Probably some combination of If and AND statements, but can't get it
    > > to work.
    > >
    > > Help greatly appreciated as ever.

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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