You'll have to give us more than that. Can you share the exact calculation you've created?
Here is the data
if contains ([Value],"status completed") Then "DONE"
Eleseif contains([Valuve],"status") Then "Pending"
But i am getting
The CONTAINS function is case sensitive, so watch out for that.
If it's not working, can you provide a sample workbook ?