View Single Post
  #1   Report Post  
John
 
Posts: n/a
Default 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