functions
 

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

functions
 

Im not quite sure how you are using K but generally.....
=if(x<72,your formula,if(and(x72,x<300),your formula,"Error")
This does not take into account x=72 you may need to adjust accordingly.
Also with this formula if x=72 then the formula will return error

"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

functions
 

If 0.11 is accurate enough, perhaps the following. Here, A1 holds your 'x
value

=MAX(1.17,POWER(300/A1,0.11))

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Al" wrote in message
...
Im not quite sure how you are using K but generally.....
=if(x<72,your formula,if(and(x72,x<300),your formula,"Error")
This does not take into account x=72 you may need to adjust accordingly.
Also with this formula if x=72 then the formula will return error

"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