Combining multiple IF AND statements with a condition

[Demona26]

Hello all.
Each of the 2 below formulas works on their own

=IF(A11<>"",IF(AND($E$7>=.4,$E$7<1),$C$7*$D11,"")
=IF(A11<>"",IF(AND($E$7>=.4,$E$7>1),$C$7*$F7,$C$7*$F7))

I need to combine these, but I can't seem to do it. Can anyone help?
To further explain what I am trying to do...

I am trying to tell Excel that if A11 is not blank, run this formula if cell E7 is above .4 but below 1, or run this formula if E7 is between .41 and 1.

Any help would be appreciated

 

[jtakw]

Hi,

Need some clarification here.
What if E7 is exactly 1?
You say if E7 is "above" .4, but your formula says "equal or greater"?
Your second formula, for the second IF test, you have $C$7*$F7 for both "value if true" And "value if false", so as long as A11 isn't Blank, it'll Always be $C$7*$F7?

This is based on what I THINK you want:

Book1
	A
1
Sheet43

Cell Formulas
Range	Formula
A1	=IF(A11<>"",IF($E$7>=0.4,IF($E$7<1,$C$7*$D11,$C$7*$F7)),"")

 

[Robby19]

Try this,

=IF(AND(ISBLANK(A11),$E$7>=0.4,$E$7<1),$C$7*$D11,IF(AND(ISBLANK(A11),$E$7>1),$C$7*$F$7,$C$7*$F$7))

Nested IF formula. Just tested on my end. Should work for you.

 

[Scott R]

=IF(A11="","",IF(AND(E7>0.4,E7<1), "formula1", "formula2"))