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

B

BenjieLop

greg7468 said:
=IF(AND(A2>1,A2<(B2-C2)),"x")
Click to expand...

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.
 
Top