I work in an Israeli company, and they like to create complex scalable commission systems. For example: If I make between number1 and number2 then I get 5%, if between number2 and number3 it's 8%, and between number3 and number4 it's 10%. Is there single function I can enter into my commission column (F) that would make this work?
Bookmarks