Thread: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
View Single Post
  #2  
Old 06-23-2005, 10:47 AM
greg7468 greg7468 is offline
Forum Contributor
  
Join Date: 03 May 2004
Location: England
MS Office Version:2003 Excel
Posts: 118
greg7468 is becoming part of the community
=IF(AND(A2>1,A2<(B2-C2)),"x")
__________________
Greg.

"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
Reply With Quote