|Thanks for the examples.|
Here's how I went about this...
First, based on your examples, I am assuming that only integers will appear in S19. Since your conditions jump from 229 to 230 and 430 to 431, I'm assuming 229.5 or 430.23 will never appear in S19.
Second, your lowest value for S19 is 1, so I'm also assuming that 0, -1, etc. are not valid entries.
Both of these issues can be addressed, but for the sake of simplicity, I'm going with those 2 assumptions.
OK, here we go...
It appears that you have some conditions whose desired results are not dependent on whether or not G19 contains text:
4 & 7 - "1.358-S19/1200" if 430 < S19 <551
5 & 8 - "Reject" if S19 > 550
Therefore we can test for those conditions first, without worrying about G19:
That leaves us with with only one condition where G19 does not contain text - Item 6, whose result is "1" - so the only thing we have to test for is text, or actually, the absence thereof:
If we've made it this far through the formula then S19 is not between 431 and 550, it's not over 550, and G19 must contain text. So now we'll test for Items 1 & 2. If neither of them are true, the only condition left is Item 3, whose result is "1":
Combining all of those together we get: