Logical conditions... could somebody help me

J

jimmy

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
 
P

pinmaster

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

Regards!
Jean-Guy
 
Top