Thread: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
View Single Post
  #3  
Old 06-23-2005, 11:43 AM
BenjieLop BenjieLop is offline
Forum Guru
  
Join Date: 23 Jun 2004
Location: Houston, TX
Posts: 567
BenjieLop is becoming part of the community
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.
__________________
BenjieLop
Houston, TX
Reply With Quote