functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Blades - 20 Mar 2006 15:59 GMT

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

Reply to this Message

Al - 20 Mar 2006 16:07 GMT

Im not quite sure how you are using K but generally.....
=if(x<72,your formula,if(and(x>72,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

> Hi
>
[quoted text clipped - 11 lines]
>
> cheers rich

Reply to this Message

Dana DeLouis - 20 Mar 2006 16:42 GMT

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

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

Signature

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

> Im not quite sure how you are using K but generally.....
> =if(x<72,your formula,if(and(x>72,x<300),your formula,"Error")
[quoted text clipped - 16 lines]
>>
>> cheers rich

Reply to this Message