Hello,
Thanks for reading my post. I would like to have some help on an if statements with 3 criteria.
I have attached a worksheet here. Commission rate is 10% with 3 exceptions:
1) If column A match any value in column K, zero commission
2) If column b > column c, zero commission
3) if in Column A the number is ANDR05, and column B is less than column C, then 5% commission, If column c is greater than column B, zero commission
Thanks for the help.
Jackson
Bookmarks