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

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

Try:

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

Change the Column & Row to suit and copy down.

Or did you mean:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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

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

Thank you Sandy Mann,

the formula works fine!

"Sandy Mann" wrote:

Try:

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

Change the Column & Row to suit and copy down.

Or did you mean:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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