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.

=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.

Hi Andy

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

--
Regards

Roger Govier


"Andy" <[email protected]> wrote in message
news:[email protected]...
>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.

Spot on. Cheers everyone!

"Roger Govier" wrote:

> Hi Andy
>
> =IF(AND(A1="",B1<>""),"whatever_you_want","")
>
> --
> Regards
>
> Roger Govier
>
>
> "Andy" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>