Thanks in advance for any help.
I trying to calculate a final commission value based on various parameters as follows...
If the sales value £1000 or less then the commission is 0%
From £1001 to £2999 the commission is 20%
From £3000 to £5999 the commission is 25%
Above £6000 the commission...