How to: free text cell, that can also assume a value depending on other cell?

Note: I would suggest that you use Nested IF statements rather than IFS. The IFS function is very inefficient as it has to evaluate every criterion and every result before selecting the first matching result.