How about in A1 thru A4

=
1
<
2


then anywhere =QWERTY() will give you TRUE:

Function qwerty()
Dim s As String
s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1)
qwerty = evaluate(s)
End Function
--
Gary's Student


"Sloth" wrote:

I want to combine cells into a logical test. I can't explain what I want, so
here is an example.

Example 1:
Input
A1: 1
A2: <
A3: 2
A4: ???Formula???
Result
A4: True