Excel Formula 2

[wrk6718]

Determining Sales Bonuses In Excel:
If the sales person exceedes the quota by $1,000 he/she gets $250; if he/she exceeds the quota by $2,000 he/she gets $500.
A1= Quota
A2= Amount of Sales
A3= Difference between A2-A1
A3= Bonus amount

How do you write the formula?
Many thanks!

 

[MarkBeck]

=CONCATENATE("Exceeded by ",SUM(A2,-A1),"; ","Your bonus will be ",IF(SUM(A2,-A1)>=2000,500,IF(SUM(A2,-A1)>=1000,250," Does not qualify for Bonus!")))

 

[SkipVought]

Hi,

If the sales person exceedes the quota by $1,000 he/she gets $250; if he/she exceeds the quota by $2,000 he/she gets $500.
A1= Quota
A2= Amount of Sales
A3= Difference between A2-A1
A3= Bonus amount

A3: = IF(A2-A1>2000,500,IF(A2-A1>1000,250,0))

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

sorry...
[tt]
=IF(A3>2000,500,IF(A3>1000,250,0))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884