Alongside Excel's TRIMRANGE function and Trim Refs operators, there are other ways to clean up your data in Excel, such as using Power Query or making the most of AI through Copilot.

If you remove the > sign, Excel accepts the function and returns 0 because no value equals the highest commission from last year, $2,710.79. The problem is the comparison operator, >.

Multiplication Operator Excel uses the multiplication operator in the form of an asterisk to perform multiplication in a cell. It can be used alone or together with other operators.