I didn't do an exhaustive rewrite but you're using & instead of 'and' as your conjunction which is probably the main reason it's not dong parts of your formula. & is used for string concatenation where as 'and', 'or' is for logic. So take your first line for example, it should look more like this:
[Customer - Superintendent 1 - Name]="Mike Andrus" and [GM%]>0.4299 and [GM%]<=0.4499,[Total Invoiced]*0.01,
Using & is why it kept failing and forcing you to make it text, the above is an example of using and as the operator that you should switch all your conditions to then retest.
------------------------------
Chayce Duncan
------------------------------
That was it! Thank you so much! I knew it had to be one small thing messing me up.
