Hi,

Change OR to AND

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

Mike

"MKuria" wrote:

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

--
mmk