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.