blank cells

  • Thread starter Thread starter RichardO
  • Start date Start date
R

RichardO

Hello All:

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

Thank you very much.


RichardO
 
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.
 
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 said:
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.
Click to expand...
 
Three possibilities,

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

Charlie O'Neill
 
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.
Chris R. Lee said:
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]...
Click to expand...
 
Back
Top