If (cell a2 is greater than 1, but less than B2 - C2, "X") how do

#1 06-23-2005, 11:05 AM

greg7468 · #2 06-23-2005, 11:47 AM

=IF(AND(A2>1,A2<(B2-C2)),"x")

BenjieLop · #3 06-23-2005, 12:43 PM

Quote:

Originally Posted by greg7468

=IF(AND(A2>1,A2<(B2-C2)),"x")

Technically, there should be another argument in the above formula, i.e., the ELSE argument in the IF/THEN statement. One way is

=IF(AND(A2>1,A2<(B2-C2)),"x","")

which will return a blank cell if the A2 conditions are not met.

Regards.

Welcome to the Excel Forum

Forum Statistics