Help with formula
 

I would like Col B to test Col A and enter a Y, N, or nothing

In Cell B2:

If A2 < A3, place a "Y" in B2, otherwise "N"
OR
If A2 = "" then don't place anything in B2

Thanks -- Suz

Help with formula
 

=IF(A2="","",IF(A2<A3,"Y","N"))

--
Gary''s Student - gsnu200760

Help with formula
 

Thanks -- I was working the formula backward.

Is there any way to do this in data validation? (the number of rows may vary
between 2 and 2,000)

"Gary''s Student" wrote:

=IF(A2="","",IF(A2<A3,"Y","N"))

--
Gary''s Student - gsnu200760

Help with formula
 

Sure. We just need to assume that either A2 is entered first and the
validation go on A3 or visa versa.
--
Gary''s Student - gsnu200760


"Suzanne" wrote:

Thanks -- I was working the formula backward.

Is there any way to do this in data validation? (the number of rows may vary
between 2 and 2,000)

"Gary''s Student" wrote:

=IF(A2="","",IF(A2<A3,"Y","N"))

--
Gary''s Student - gsnu200760