Assuming x is in A1.

=if(a1<72,1.17,if(a1<300,(300/a1)^0.11,"Over 300"))

Your problem statement leaves out what to do when x = 72


"Blades" wrote:

Hi

I am trying to discover a formula/function that will allow me to do the
following!

my problem is this:

x = 100mm

if x <72 then k = 1.17
if 72 < x< 300 then k = (300/x)^0.11

can anyone tell me how i can combine these into one function?

cheers rich