Hi All,

Relatively beginner level with Excel but I've been tasked with creating a spreadsheet to track and calculate sales commission at my work.

It's a tiered commission with the below structure based on monthly billings:

£0-£4000 = 0%
£4,001-£15,000 = 20%
£15,001+ = 30%

Does anyone have any tips on how's best to go about creating the formula's to calculate this - I've checked a few different places and they seems to suggest an IF or VLOOKUP but not sure what's best.

Help is much appreciated!

Thanks