What is the best function?

[Paully03]

I would like to calculate tax in excel. However, the percentage of tax that a customer would pay is dependent on the purchase price.

less than $4000	0%
$4000-$10,000	3.5%
$10,000 or more	6.5%

how would I enter the function To calculate if I enter the amount in excel it will 1) choose the correct percentage based off the chart above and 2) (if at feasible) calculate that chosen percentage with the purchase price.

thank you

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this the sort of thing you are after?

22 07 07.xlsm
	A	B	C	D	E	F
1	Price	Tax			Base	Tax Rate
2	4350.00	152.25			0	0%
3	88.90	0.00			4000	3.50%
4	15000.00	975.00			10000	6.50%
Tax

Cell Formulas
Range	Formula
B2:B4	B2	=XLOOKUP(A2,E$2:E$4,F$2:F$4,,-1)*A2