blank cells

[RichardO]

Hello All:

I would like to write a formula:
if cell A1 is blank, yes, otherwise no.

Thank you very much.


RichardO

 

[Michael J. Malinsky]

=IF(A1="","YES","NO")

 

[Norman Harker]

Hi RichardO

=IF(ISBLANK(A1),"yes","no")

But want do you mean by blank? If you regard a formula that returns ""
as being blank, then the above will return "no" because A1 is not
blank; it contains a formula.

=IF(A1="","yes","no")



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Chris R. Lee]

This one keeps coming back.

We have a formula that finds if a cell is Blank (Empty is the term used by
older and better structured mainframe computer applications). We need one to
declare a cell Empty.

Regards

Hi RichardO

=IF(ISBLANK(A1),"yes","no")

But want do you mean by blank? If you regard a formula that returns ""
as being blank, then the above will return "no" because A1 is not
blank; it contains a formula.

=IF(A1="","yes","no")



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Charlie]

Three possibilities,

=IF(ISBLANK(A1),"YES","NO")
=IF(A1>0,"NO","YES")
=IF(A1="","YES","NO")

Charlie O'Neill

 

[Norman Harker]

Hi Chris!

Agreed!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

This one keeps coming back.

We have a formula that finds if a cell is Blank (Empty is the term used by
older and better structured mainframe computer applications). We need one to
declare a cell Empty.

Regards


"Norman Harker" <[email protected]> a écrit dans le message de u#[email protected]...