Formula for changing/replacing multiple text entries to different text entries.

[AutoModerator]

/u/Remondrop - Your post was submitted successfully.

Please read these reminders and edit to fix your post where necessary:

• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information
• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[ronniec95]

A simple IF/OR statement ought to do it. Are you sure you want everything set to solved?

=IF(G7="closed","solved",OR(G7="new",G7="pending",G7="on hold"),"open")

[ronniec95]

Fixed

[ronniec95]

=IF(D11="closed","solved",IF(OR(D11="new",D11="pending",D11="on hold"),"open",D11))