Returning a value with a minimum and maximum collar

[confusedbuttrying]

Hi all,

Please can someone help me out of a pickle?

I have a simple calculation: 20 / 40 = 0.5
20 is a fixed value and 40 is variable

I need it so that the answer can never be less than 0.25 or greater than 0.75


I figure that:

=MIN(E18,(SUM(B15/D15))) delivers the minimum of 0.75 or the actual output of the sum, and
=MAX(E19,(SUM(B15/D15))) delivers the maximum of 0.25 or the actual sum

Is there a way of combining these two to automate the routine? Or a different process that would get me the result?

Thank you

 

[Fluff]

Hi & welcome to MrExcel.
How about
=MEDIAN(0.25,B15/D15,0.75)

 

[ER_Neha]

mr excel1.xlsx
	A	B	C	D	E
1	Number 1	Number 2	N1/N2		VALUE
2	5	10	0.5	MINIMUM=	0.25
3	1		0.25	MAXIMUM=	0.75
4	15		0.75
5	20		0.75
6	40		0.75
7	30		0.75
8
Sheet3

Cell Formulas
Range	Formula
C2:C7	C2	=IF(A2/$B$2<$E$2,$E$2,IF(A2/$B$2>$E$3,$E$3,A2/$B$2))

 

[confusedbuttrying]

Hi & welcome to MrExcel.
How about
=MEDIAN(0.25,B15/D15,0.75)

That's fantastic!

Thank you so much. I've been trying to figure that out since 11:00 this morning

Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.