Hi,

I am a bit of an excel novice, besides basic formulae. I would like to create a simple formula that will calculate bonus payments based on the following structure:

Income 0 - 150,000, bonus = 0
Income 150,001 - 300,000, bonus = 30% of this amount
Income 300,001 - 400,000, bonus = 35% of this amount
Income 400,000 +, bonus = 40% of this amount.

Any help on the best way of setting this up would be greatly appreciated.

C