# If Function for BLANK cells

1. ## 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. ## 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. ## 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. ## 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.

>
>
>

##### Users Browsing this Thread

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

#### 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