2 If Statements between 2 values Q

[John]

I am trying to write 2 IF Statements and am having problems

1) If C11 is between .85 & .99 then Return Rates!G14
2) If C11 is greater than .99 then Return Rates!C14

I thought it was this

=(IF(C11>=0.85,Rates!G14)*OR(IF(Starters!C11<=0.99,Rates!G14)))*(IF(C11>.99,
Rates!C14))

But its not coming up with my expected result

 

[Ben McBen]

simpler than you are trying:

If takes 3 args - test, trueresult, falseresult

in your case it sounds like

IF(and(test1, test2), val1, val2)

or

 

[Ron Rosenfeld]

I am trying to write 2 IF Statements and am having problems

1) If C11 is between .85 & .99 then Return Rates!G14
2) If C11 is greater than .99 then Return Rates!C14

I thought it was this

=(IF(C11>=0.85,Rates!G14)*OR(IF(Starters!C11<=0.99,Rates!G14)))*(IF(C11>.99,
Rates!C14))

But its not coming up with my expected result

Note that, as you defined the problem in your lines 1 and 2, that if C11 = 0.85
or less, or C11=0.99, the result is undefined.

If this is not what you want, you may want to change one or more of the
"greater than" or "less than" symbols to "equal or greater than".

=IF(AND(C11>0.85,C11<0.99),'Return Rates'!G14,IF(C11>0.99,C14,"Undefined"))

Another formula that returns zero for undefined C11 and does not require
nesting:

=AND(C11>0.85,C11<0.99)*'Return Rates'!G14+(C11>0.99)*'Return Rates'!C14



--ron

 

[John]

Thanks Ron, works great

,

Note that, as you defined the problem in your lines 1 and 2, that if C11 = 0.85
or less, or C11=0.99, the result is undefined.

If this is not what you want, you may want to change one or more of the
"greater than" or "less than" symbols to "equal or greater than".

=IF(AND(C11>0.85,C11<0.99),'Return Rates'!G14,IF(C11>0.99,C14,"Undefined"))

Another formula that returns zero for undefined C11 and does not require
nesting:

=AND(C11>0.85,C11<0.99)*'Return Rates'!G14+(C11>0.99)*'Return Rates'!C14



--ron

 

[Ron Rosenfeld]

Thanks Ron, works great

You're welcome. Thank you for the feedback.

--ron