if statement help please. Wrong value being returned.

[Mechjo16]

if statement fix.xlsx

Hi all.

I hope someone can help.

I am trying to return a value open or closed in a cell depending on if a item is completed or not. The problem is I always return open because the cell that holds "Completed" I am looking at has a date in it as well.

Example (the first one should say closed because both are completed). 1st line has attachment

[FDibbins]

Hi and welcome to the forum

Try something like this - assuming your data is in A1...

=if(A1="*"&"Completed"&*"*,"Completed","Open")

[Mechjo16]

Hi and welcome to the forum

Try something like this - assuming your data is in A1...

=if(A1="*"&"Completed"&*"*,"Completed","Open")

Thanks for the reply. I kept getting an error when I input that formula. I updated my post and attached a example of my problem in line one.

[Tony Valko]

Maybe this...

Entered in C3 and copied down:

=IF(COUNTIF(E3:H3,"*Completed*")=4,"Completed","Open")

[Mechjo16]

Maybe this...

Entered in C3 and copied down:

=IF(COUNTIF(E3:H3,"*Completed*")=4,"Completed","Open")

Great! That will do it. thanks!! I tried that once but didn't know I had to do the " =4" part.

[Tony Valko]

You're welcome. Thanks for the feedback!