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
|