Dear Excel Discussion Group

  • Thread starter Corcovadocowboy
  • Start date
C

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
 
G

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?
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
C

Corcovadocowboy

Thank you Gaurav, the formula works fine!

Gaurav said:
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?
Click to expand...
 
C

Corcovadocowboy

Thank you Sandy Mann,

the formula works fine!

Sandy Mann said:
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Top