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