title: How we can do this in google sheet? multiply based on condition
body: <p>I have data in google sheet and I want to get this </p>
  
  <p>I have numbers value in B Column and want to multiply based on condition, Like if numbers above 650 in column B then formula insert value in Column C 125 if value bellow 650 in column B then formula multiply value with 0.16 like 648*0.16 and want final result in column C. If value above 850 in Column B  then also formula multiply value with 0.16 like 855*0.16 and final result in Column C .</p>
  
  <p>Here is ex:</p>
  
  <p><a href="https://i.imgur.com/h1xuhHd.png" rel="nofollow noreferrer"><img src="https://i.imgur.com/h1xuhHd.png" alt="enter image description here"></a></p>
  
  <p>Sorry for the bad English.</p>
  
  <p>I tried this </p>
  
  <pre><code>=B2 * IF(B2 &gt; 650,(0+125), IF(B2 &lt; 649,0.16, IF(B2 &lt; 850, 0.16, 0)))
  </code></pre>
  
  <p>but it does not insert 125 value as its X with 125 I don't want to multiply if value above 650 and bellow 850. so please help me with this.</p>