need help to fit in the third criteria. =(

[fjillzie]

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")

 

[cml19722000]

Try this: -

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

 

[Aladin Akyurek]

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"))

 

[fjillzie]

Try this: -

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

OMG! it works! thank you so much!

 

[fjillzie]

ADVERTISEMENT

Something like:

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

this works as well, thank you so much.

 

[fjillzie]

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

 

[fjillzie]

ADVERTISEMENT

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'?

 

[temens]

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"))))

 

[fjillzie]

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 <>