close
Assuming x is in A1.
=if(a1lt;72,1.17,if(a1lt;300,(300/a1)^0.11,quot;Over 300quot;))
Your problem statement leaves out what to do when x = 72quot;Bladesquot; wrote:
gt; Hi
gt;
gt; I am trying to discover a formula/function that will allow me to do the
gt; following!
gt;
gt; my problem is this:
gt;
gt; x = 100mm
gt;
gt; if x lt;72 then k = 1.17
gt; if 72 lt; xlt; 300 then k = (300/x)^0.11
gt;
gt; can anyone tell me how i can combine these into one function?
gt;
gt; cheers rich
全站熱搜
留言列表
