More than one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this formula in a cell: =IF(ISBLANK(A6),1,2). It works fine. If I want a series of cells to be blank, how do I get that to work? I tried =IF(ISBLANK(AND(A6,B6,C6,D6)),1,2), but that doesn't work.

Thanks,
HF
 
Hi Howard!

Two approaches:

Sledgehammer:
=IF(AND(ISBLANK(A6),ISBLANK(B6),ISBLANK(C6),ISBLANK(D6)),1,2)
Not very friendly if you have many blank cells to check!


Array Entered:
=IF(AND(ISBLANK(A6:D6)),1,2)
Press and hold down Ctrl + Shift and then press Enter
Appears in cell as:
{=IF(AND(ISBLANK(A6:D6)),1,2)}


--
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.
Howard said:
I have this formula in a cell: =IF(ISBLANK(A6),1,2). It works fine.
Click to expand...
If I want a series of cells to be blank, how do I get that to work? I
tried =IF(ISBLANK(AND(A6,B6,C6,D6)),1,2), but that doesn't work.
 
Hi Howard!

And I'll have to remember the existence of COUNTA!! Designed to count
the number of blank cells in a range. There's no point using an array
for this purpose although for other instances it could be useful.

--
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.
 
Back
Top