Formula Syntax Error

When you have a formula this long there is a good indication that your app should be redesigned to have a table of rates and lookup the rate from the table.

My suggestion is to make a table with a hyphenated Key field like
Labor Category-Status-Hours Category.  It will get populated by a form rule which refers to a formula which calculates that Hyphenated value from the drop down multiple choice fields.

But I can try to help you debug this.  

You would be better served with more spacing of your formula.  I first use a formula variable to calcuate the Rate.


var number Rate = 


If(
[Associate - Labor Category]= "Carpenter"
and [Staff Status]= "Dedicated"
and [Hour Category]= "Standard",[Labor Rate - Dedicated Standard Rate],


[Associate - Labor Category]= "Carpenter"
and [Staff Status]= "Dedicated"
and [Hour Category]= "Premium",[Labor Rate - Dedicated Premium Rate],

[Associate - Labor Category]= "Carpenter" and
[Staff Status]= "Variable"
and [Hour Category]= "Standard",[Labor Rate - Variable Standard Rate],

etc


[Associate - Labor Category]= "Superintendent"
and [Staff Status]= "Variable"
and [Hour Category] = "Premium",[Labor Rate - Variable Premium Rate]);

// now we refer to the rate and multiply by the hours

$Rate * [Hours]


~~~~~~~~~~~~~~~~~

btw, the other advantage of using a table is that once you lookup the rate you can use a snapshot field to freeze it so that next year when the rates may change, you will not affect the historical records.

https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html