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

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


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381588

greg7468 Wrote:
=IF(AND(A21,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(A21,A2<(B2-C2)),\"X\",\"\")

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

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381588