formula between two values

[Blackwell]

I am trying to find the right formula for the value between two values and if they are to be in cell D1. not sure if it's an =If, max, min

A1 B1 C1 D1
8,500 3142 - 12500 ? 8,500

 

[Joe4]

From your post, it is not clear which numbers are in what cells. All your data is mashed together.
Can you post a screen print so that it is clearer?

 

[Fluff]

Is this what you mean?

Fluff.xlsm
	A	B	C	D
1	8500	3142	12500	8500
Master

Cell Formulas
Range	Formula
D1	D1	=MEDIAN(A1:C1)

 

[Blackwell]

I hope this is ok for you and it does explain. What I am after is if the value of sales is 13,000, I am trying to get the 40% and 45% tax correct. I want the sales value between 3142 and 12500 to input that figure in the cell, say C20 and then over the 12,500 45% to put that value in the C 21, allowing for the difference for the allowance over 100,000. I have a formula for the total tax which is
=MAX(MAX(B1-150000,0)*0.45+MIN(MAX(B1-50270,0),150000-50270)*0.4+MIN(B1-12570,50270-12570)*0.2+MAX((MIN(B1,100000+12570*2)-100000)/2,0)*0.4,0). I want to breakdown each tax percentages for 20%, 40% and 45%. I can upload an excel spreadsheet if required.

 

[Fluff]

I'm afraid that makes no sense to me, probably because I know nothing about tax calculations.

 

[Blackwell]

Thank you for trying Fluff.

 

[Blackwell]

I have managed to resolve this formula nearly, but not entirely. I require a formula to give me the value between c2 and c3 in cell C4.
sales between end result
C1 C2 C3 C4
14,000 3142 12,500 9,358
I have tried this: =IF((C1-C$2)>0,C1-C$2,0), but it misses the value 12,500 C3. Not sure how to add the C3 in the formula? Any help would be appreciated.

		14,000​
		3142​
		12500​
		9358​
		​

 

[Joe4]

I am very confused by your description. Are you saying that the value in C4 is calculated?
It looks to me like your are subtracting the smallest value (3142) from the median value (12500).

If that is really what you are after, this formula would work in cell C4:

=MEDIAN(C1:C3)-MIN(C1:C3)

 

[Blackwell]

Many thanks; Joe4 have been trying all day and did not think of that formula. Great, thank you; it works great.

 

[Joe4]

You are welcome.
I am glad my guess was correct!