IF AND formula needed

[londa_vba]

Hello
Is there a way to combine all the following scenarios into one formula or two formulas in Excel

First logical is Quantity (D9) < Target (E9)

If first logical test = false, then Target (E9) / Quantity (D9)

If first logical test = true And If (Quantity (D9) / 10) < 1 = 10
-OR-
If first logical test = true And If Quantity (D9) / 10 > 1 = 100

Lastly based on whether the answer to the second logical test is 10 or is 100....
I need the true result to be Target (E9) / (Quantity (D9) / either 10 or 100)

 

[DanteAmor]

Try:

Libro1
	D	E	F
9	10	20	0.02
Hoja1

Cell Formulas
Range	Formula
F9	F9	=E9/D9/IF(D9<E9,IF(D9/10<1,10,100),1)

 

[ExceLoki]

try this

=IF(D9<E9,E9/D9/IF(D9/10<1,10,100),E9/D9)

 

[londa_vba]

Try:

Libro1
	D	E	F
9	10	20	0.02
Hoja1

Cell Formulas
Range	Formula
F9	F9	=E9/D9/IF(D9<E9,IF(D9/10<1,10,100),1)

I appreciate the attempt. That code did not work for me.
I am using D9=0.19, E9=0.75, and answer should = 3.87 to check the false statement.
I am using D9=11.42, E9=0.75, and answer should = 6.57 to check one option for the true statement.

 

[londa_vba]

I appreciate the attempt. That code did not work for me.
I am using D9=0.19, E9=0.75, and answer should = 3.87 to check the false statement.
I am using D9=11.42, E9=0.75, and answer should = 6.57 to check one option for the true statement.

Sorry that actually did work for me. THANK YOU SO MUCH!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.