Excel Question (1 Viewer)

[cubd8]

This sounds simple, but can't get this to calculate correctly:

I have this formula in a field called: Associate Capacity Score (Column BS)

=[@[Complexity Adjustment]]+[@[Setup Description Adjustment]]+[@[Order Status Adjustment]]+[@[Order Type Adjustment]]+[@[High Touch Adjustment]]

I want to change this formula to multiply one of these columns by the aggregate total of the other columns:

[@[Order Status Adjustment]] * ([@[Complexity Adjustment]]+[@[Setup Description Adjustment]]+[@[Order Type Adjustment]]+[@[High Touch Adjustment]]

Any idea's on the syntax for this? should be easy, but I'm getting error's or the math isn't multiplying.

 

[kutta]

I don't see a closing ")"

 

[cubd8]

Thank you! My eyes were missing that!