need help with a forumula

[bigbosky32]

ok so im trying to set up this excel sheet for work to track my crews errors


and adjust their incentive bonus.


so heres what i want to do

lets say in cell A1 is the number of errors this person made
- If this person made 0 errors then nothing happens
- if this person makes 1 error then 25% will be subracted from
whatever is in cell A2
- If he makes 2 errors then 50%
- If he makes 3 errors then 75%

i've only had a few basic excel classes so im really scratching my head on this one any help would be appreciated.

[phroche]

if(a1=0,b1,if a1=1,b1-(b1*.25),if a1=2,b1-(b1*.50),if a1=3,b1-(b1*.75),0)
bonus=100
error = 0 bonus = 100
error = 1 bonus = 75
error = 2 bonus = 50
error = 3 bonus = 25
error > 3 bonus = 0

You can on do 7 layers of nesting.