2 If Statements between 2 values Q
 

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

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

On Mon, 13 Dec 2004 10:52:43 -0000, "John" wrote:

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.9 9,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(C110.85,C11<0.99),'Return Rates'!G14,IF(C110.99,C14,"Undefined"))

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

=AND(C110.85,C11<0.99)*'Return Rates'!G14+(C110.99)*'Return Rates'!C14



--ron

Thanks Ron, works great


"Ron Rosenfeld" wrote in message
...
On Mon, 13 Dec 2004 10:52:43 -0000, "John"
wrote:

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.9 9,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(C110.85,C11<0.99),'Return
Rates'!G14,IF(C110.99,C14,"Undefined"))

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

=AND(C110.85,C11<0.99)*'Return Rates'!G14+(C110.99)*'Return Rates'!C14



--ron

On Mon, 13 Dec 2004 12:59:30 -0000, "John" wrote:

Thanks Ron, works great

You're welcome. Thank you for the feedback.

--ron