# need help to fit in the third criteria. =(

#### fjillzie

##### New Member
Hi guys,

Need your help on this, wondering if this can work.

How do I make the text in cell E6 change to:

1) 'Unassigned' if cell L3 is empty.
2) 'Assigned' if cell L3 is not empty.
3) 'Completed' if both cell L3 and M3 are not empty.

I found this formula stated below that will help me with first and second, but not the last one.

=IF(ISBLANK(L3),"Unassigned","Assigned")

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Try this: -

=IF(AND(L3<>"",M3<>""),"Completed",IF(L3<>"","Assigned",IF(L3="","Unassigned")))

Hi guys,

Need your help on this, wondering if this can work.

How do I make the text in cell E6 change to:

1) 'Unassigned' if cell L3 is empty.
2) 'Assigned' if cell L3 is not empty.
3) 'Completed' if both cell L3 and M3 are not empty.

I found this formula stated below that will help me with first and second, but not the last one.

=IF(ISBLANK(L3),"Unassigned","Assigned")

Something like:

=IF(L3="","unassigned",IF(M3<>"","completed","assigned"))

Try this: -

=IF(AND(L3<>"",M3<>""),"Completed",IF(L3<>"","Assigned",IF(L3="","Unassigned")))

OMG! it works! thank you so much!

Something like:

=IF(L3="","unassigned",IF(M3<>"","completed","assigned"))

this works as well, thank you so much.

sorry guys, is it still possible to have another criteria say if both cells are empty, the cell text will be 'not applicable'?

Try this: -

=IF(AND(L3<>"",M3<>""),"Completed",IF(L3<>"","Assigned",IF(L3="","Unassigned")))

sorry to trouble, but is it still possible to have another criteria say if both cells are empty, the cell text will be 'not applicable'?

Just add another IF Statement to the first solution, like this:

=IF(AND(L3<>"",M3<>""),"Completed",IF(AND(L3="",M3=""),"Not Applicable",IF(L3<>"","Assigned",IF(L3="","Unassigned"))))

Just add another IF Statement to the first solution, like this:

=IF(AND(L3<>"",M3<>""),"Completed",IF(AND(L3="",M3=""),"Not Applicable",IF(L3<>"","Assigned",IF(L3="","Unassigned"))))

thanks temen.. now i also fully understand the meaning of "" and <>

Replies
0
Views
585
Replies
3
Views
377
Replies
1
Views
965
Replies
5
Views
209
Replies
7
Views
1K

1,196,237
Messages
6,014,163
Members
441,807
Latest member
sjkenjalo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back