Multiple functions from single cell

[Nick1966]

I have a bonus system and need to pay sales reps on performance.

Lets say they have 3 levels of performance, (N2)20,000 for base (N3)22,000 for forecast and (N4)24,000 for target.

I need to say in a single cell that if they achieve 20,500 pay (say £100) but if they achieve 23,000 pay (say £200) but if they achieve 25,000 pay (say£500).

Hope this is self explanatory. I have the first part of the formula (N2) and it recognises the need to pay £100 but I have tried adding the other parts to the formula but it does not recognise them.

Thanks

[Chris 53]

Assume performance achieved is in N1 3 levels are in N2,N3 and N4.

if(n1>= n4,500,if(n1>=n3,200,if(n1>=n2,100,0)))

[Nick1966]

Chris
Many Thanks - worked perfectly!!
Nick