Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
I would like cell B1 to return the value in cell A1 if that value is either 1 or greater (the number of coffins sold to customers) or if it is minus 1 or less (the number of coffins returned by dissatisfied customers). If the value is between those two, i.e. .5, 0 or NO ENTRY AT ALL, I would like B1 to return "Incorrect Input, Fool!"
The Lotus formula was:
@IF(A1>1#AND#A1<-1,"Incorrect Input, Fool",A1)
The AND function in Excel seems to only return TRUE or FALSE.
The Lotus formula was:
@IF(A1>1#AND#A1<-1,"Incorrect Input, Fool",A1)
The AND function in Excel seems to only return TRUE or FALSE.