Hi,
I am new to the forum and have only basic knowledge of Excel. I am trying to figure out how to create a conditional formula, and would be very grateful for your help. Basically, I am trying to calculate a commission on a sales price where the commission is 3% of the sales price if the sales sum is 1.100.000 or less, and 10% commission on any amount exceeding 1.100.000. So, I'm looking for something like:
If < than 1.100.000, then I want it the cell to return the value of 3% of 1.100.000. If > 1.100.000, then I want the cell to return 3% of 1.100.000 PLUS 10% of any amount that exceeds 1.100.000. Does that make sense?
Any help appreciated!
Bookmarks