Dec 19 2021 03:33 AM
Hi folks,
Dec 19 2021 03:58 AM
See the attached version. I added a column with the threshold values to the Commission Rates sheet.
The formula for the commission rate is =VLOOKUP(A2,'Commission Rates'!$B$2:$C$14,2)
If you want the commission as an amount, use =VLOOKUP(A2,'Commission Rates'!B2:C14,2)/100*B2
Dec 19 2021 04:00 AM
@Kev__uk Added something to your file. See if this is what you need.