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, >. Excel simply ...