Excel formula to adjust for a short fall?

[Brustigian]

Hello, what is the best Excel formula to adjust for this shortfall?

[TABLE="width: 303"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Revenue Split[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Revenue[/TD]
[TD="align: right"]$5,000[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Agent (80%)[/TD]
[TD="align: right"]$4,000[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]Broker (20%)[/TD]
[TD="align: right"]$1,000[/TD]
[TD="align: right"]20%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Minimum Broker Revenue $1,500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Agent Adjusted Payout ($4,000 - $500 = $3,500[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Excel 2010
	A	B	C
1	Revenue Split
2	Total Revenue	$5,000	100%
3	Agent (80%)	$4,000	80%
4	Broker (20%)	$1,000	20%
5
6	Minimum Broker Revenue	1500
7	Agent Adjusted Payout ($4,000 - $500 = $3,500
8
9	$3,500
Sheet3

Cell Formulas
Range	Formula
B3	=C3*$B$2
B4	=C4*$B$2
A9	=B3-MAX(B6-B4,0)