Logical conditions... could somebody help me
 

I need to create a formula based in several criterias... i´m trying it with
logical functions but i cannot do it:

the theorethical condition is:
if cell H19 is <15 and 25 the value must be 0,
but if it is =15 and =<16 the value must be 35
if it is =17 the value must be 36
and if it is =18 and <=25 the value must be 37


Tanks for your help

Logical conditions... could somebody help me
 

Hi,

One way:

=LOOKUP(H19,{0,15,17,18,26},{0,35,36,37,0})

HTH
Jean-Guy

"jimmy" wrote:

I need to create a formula based in several criterias... i´m trying it with
logical functions but i cannot do it:

the theorethical condition is:
if cell H19 is <15 and 25 the value must be 0,
but if it is =15 and =<16 the value must be 35
if it is =17 the value must be 36
and if it is =18 and <=25 the value must be 37


Tanks for your help

Logical conditions... could somebody help me
 

Hi Jean-Guy,

It worked. You have help me a lot.
Thank you again

"pinmaster" wrote:

Hi,

One way:

=LOOKUP(H19,{0,15,17,18,26},{0,35,36,37,0})

HTH
Jean-Guy

"jimmy" wrote:

I need to create a formula based in several criterias... i´m trying it with
logical functions but i cannot do it:

the theorethical condition is:
if cell H19 is <15 and 25 the value must be 0,
but if it is =15 and =<16 the value must be 35
if it is =17 the value must be 36
and if it is =18 and <=25 the value must be 37


Tanks for your help

Logical conditions... could somebody help me
 

You're welcome....glad I could help and thanks for the feedback!

Regards!
Jean-Guy

"jimmy" wrote:

Hi Jean-Guy,

It worked. You have help me a lot.
Thank you again

"pinmaster" wrote:

Hi,

One way:

=LOOKUP(H19,{0,15,17,18,26},{0,35,36,37,0})

HTH
Jean-Guy

"jimmy" wrote:

I need to create a formula based in several criterias... i´m trying it with
logical functions but i cannot do it:

the theorethical condition is:
if cell H19 is <15 and 25 the value must be 0,
but if it is =15 and =<16 the value must be 35
if it is =17 the value must be 36
and if it is =18 and <=25 the value must be 37


Tanks for your help