Formula Syntax Error

OK, but this rate here

[Labor Rate - Dedicated Standard Rate]

When that rate changes next year, wont it mess up your historical records?  ie restate history?

I don't think so.  This comes from another table that is part of this specific 2019 contract.  The 2020 contract would have a different value.

I must be doing something wrong:

Formula syntax error

Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.

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],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Variable" and [Hour Category]= "Premium",[Labor Rate - Variable Standard Rate],
// now we refer to the rate and multiply by the hours
$Rate * [Hours] 

np, you just need to close the final bracket to match the opening bracket on the IF

[Hour Category]= "Premium",[Labor Rate - Variable Standard Rate])_

// now we refer to the rate and multiply by the hours
$Rate * [Hours] 

Got it!  Yes... problem solved.  

Thank you so much!

Great, thx for letting me know.