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