Divide by specific cell if less than

[gtd526]

Hello,
If a cell in a range (B2:B8) is less than specific cell (E9), then divide specific cell by the cell less than specific cell value.
If no cells are less than, then "no cells".

Thank you.

The Whole Enchilada.xlsm
	A	B	C	D	E	F
1	Symbol	Price	QTY	Cost		if any cell in B2:B8 is > E9, then divide E9 by that specific cell in B2:B8
2	UBOT	$22.74	14	$318.36		want to create quantity
3	CLDL	$6.25	44	$330.00
4
5
6
7
8
9		Total:	58	$648.36	$14.81	Total Remaining Funds
10
11				2	expected result
Sheet1

Cell Formulas
Range	Formula
C9	C9	=SUM(C2:C5)
D9	D9	=SUM(D2:D8)
D11	D11	=ROUNDDOWN(($E$9/B3),0)

 

[Joe4]

See if this does what you want:

=IF(MINIFS(B2:B8,B2:B8,">0")<E9,INT(E9/MINIFS(B2:B8,B2:B8,">0")),"no cells")

 

[gtd526]

See if this does what you want:

=IF(MINIFS(B2:B8,B2:B8,">0")<E9,INT(E9/MINIFS(B2:B8,B2:B8,">0")),"no cells")

Yes. Thank you!

 

[Joe4]

You are welcome.