IS BLANK checking 2 Cells

[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

 

[Mike H]

Hi,

Change OR to AND

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

Mike

 

[Bernard Liengme]

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

 

[figdatbong]

Alternatively, you could use the following formula:

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

Hope this helps?

 

[Sam Wilson]

=IF(OR(NOT(ISBLANK(A1)),NOT(ISBLANK(B1))),"Assigned","Unassigned")

 

[Shane Devenshire]

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"

 

[Rick Rothstein]

A little shorter yet...

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