Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
On Mon, 13 Dec 2004 12:59:30 -0000, "John" wrote:
Thanks Ron, works great You're welcome. Thank you for the feedback. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions |