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


"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