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" wrote in message
...
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.
|