Thank you Gaurav, the formula works fine!

"Gaurav" wrote:

Asuming your X value is in A1 and Y value is in B1. Enter this formula in
C1.

=IF(AND(A12,B1<3),"18-00-36",0)

Does that help?



"Corcovadocowboy" wrote in
message ...
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 higher than 2 and the value y of column 2 is
lower
than 3, populate the third column with the string value "18-00-36", else
return value 0.

Help very apreciated!

Thank you
gábor