If formula for determining a fee

[brutus713]

I am currently trying to figure out how to do the formula to auto determine a fee.

Basically, I have a cell with the total costs of a project, "E44"

In a new cell, I want to put the fee determined on that total.

Fee structure is a follows:

$1 - $25,000 = 6%
$25,001 - $100,000 = 5%
$100,001 - $250,000 = 4%
$250,001+ =3%

Thank you!!!

 

[jtakw]

Hi,

Assuming you don't mean a "Tier" fee, but a "Fixed" fee:

Book1
	A	B	C	D	E	F
1	1	25000	6%
2	25001	100000	5%
3	100001	250000	4%		Cost	Fee
4	250001		3%		175000	7000
Sheet232

Cell Formulas
Range	Formula
F4	=LOOKUP(E4,A1:A4,C1:C4)*E4

 

[AhoyNC]

If it's a tiered fee. First 25,000 at 6% then the next 75,000 at 5% etc.
Try:

Excel Workbook
	A	B	C	D	E
1	Threshold	Rate	Rate Diff
2	$0	6%	6%
3	$25,000	5%	-1%
4	$100,000	4%	-1%	Cost	Fee
5	$250,000	3%	-1%	$175,000	$8,250
Sheet