IS BLANK checking 2 Cells

  • Thread starter Thread starter MKuria
  • Start date Start date
M

MKuria

I have a statement -
to check if both cells are blank then I need to populate with Not Assigned,
if anyone of the cells is not blank then I need it to populate with Assigned.

Here is the formula but it is not working
=IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")
if one of the cells is not blank it popluates with NOT assigned but I want
it to show Assigned.

Thanks
 
Hi,

Change OR to AND

=IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")

Mike
 
The formula =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")
is working exactly how it should: if ANY ONE of the cell is blank then you
get "Not Assigned"

The formula =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")
will give "Not assigned" only when BOTH cells are blank

So will =IF(COUNTA(AD2, AE2),"Assigned", "Not Assigned")

best wishes
 
Alternatively, you could use the following formula:

=IF(COUNTBLANK(your range)=2,"Not Assigned","Assigned")

Hope this helps?
 
Hi,

Either

=IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")

or shorter:

=IF(AND(AD2="",AE2=""),"Not Assigned", "Assigned")

or shorter still

=IF(AND(AD2="",AE2=""),"Not ","")&"Assigned"

or even shorter:

=IF(COUNTA(AD2:AE2),,"Not ")&"Assigned"
 
Back
Top