Re: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
- From: BenjieLop <BenjieLop.1r372l_1119542754.3207@xxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 10:43:34 -0500
greg7468 Wrote:
> =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.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=381588
.
- References:
- Prev by Date: Re: Dynamic Formula?
- Next by Date: Re: Compare 2 columns & format row
- Previous by thread: Re: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
- Next by thread: RE: I want data on *** 1 to input into *** 2 also
- Index(es):
