Pricing Formula Question

[joeymonts18]

Hi Everyone,

This may be very simple but I really don't know how to do it. I need to create a pricing function with the following factors:

Minimum Pricing: $2000
Maximum: $12000
Price per match: .35

I need a function that when a user plugs in a number of matches (F11), they will get a price based on the above factors. Any insight would be greatly appreciated!

Thanks

 

[sheetspread]

Excel 2010
	A	B
1	Minimum Pricing	$2,000
2	Maximum	$12,000
3	Price per match	0.35
4
5	Number	34287
6		12000
Sheet4

Cell Formulas
Range	Formula
B6	=MEDIAN(B5*B3,B1,B2)