Dear Excel Discussion Group

[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 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

 

[Gaurav]

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

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

Does that help?

 

[Sandy Mann]

Try:

=IF(AND(A1>2,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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Corcovadocowboy]

Thank you Gaurav, the formula works fine!

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

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

Does that help?

 

[Corcovadocowboy]

Thank you Sandy Mann,

the formula works fine!

Try:

=IF(AND(A1>2,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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk