Populating column with a logical function

[Corcovadocowboy]

I need to populate a column , using data from two other colums with numeric
values. The third column should be populated as following:

If value x from colum1 is smaller than 1.5 and the value y of column 2 is
lower than 3, populate the third column with the string value "110-80", and
if value x from colum1 is higher than 1.5 and smaller than 15 and the value
y of column 2 is higher than 3, populate the third column with the string
value "30-50".

Help very apreciated!

Thanks!
gábor

 

[Mike H]

Hi,

This should produce the desired results but there many holes in the logic of
your requirement you may need to think again.

For example
A1= 1.5
B1 = 3
isn't catered for in the logic you provided.

=IF(AND(A1<1.5,B1<3,ISNUMBER(A1),ISNUMBER(B1)),"110-80",IF(AND(A1>1.5,A1<15,B1>3,ISNUMBER(A1),ISNUMBER(B1)),"30-50",""))

Mike

 

[Corcovadocowboy]

Hi Mike,

thank you for your help.

The formula works for me. I know that there are some holes in this formula,
but I didn't want to complicate the formula and showed here just a part. With
your answer I could write the complete formula. Thank you. I just disn't
understand the isnumber function. I just put it out.

Rhank you again.

gábor