How would I go about automating a current ""if"" statement ?

I currently have a Formula-Text field with 10 true statements, and now I want to automate it when any 5 of the 10 true statements occur I want to change Field-X output from Y to a Z.

Any suggestion on how to make this happen?