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

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

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.