If A1=B1 and B1=C1 then
A1=C1
D1 = A1+3
End if

A1 + 3 can't equal D1 unless you are testing if they do?

--
Regards,
Tom Ogilvy


" wrote:

for an If..Then statement you can do If "A1=B1" and "B1=C1" then
A1=C1. But is there a connecting word(AND) that can be done in the
then part. such as......If (A1=B1) and (B1=C1) then (A1=C1) And
(A1+3=D1)

I know the syntacs aren't correct its an example to get the point
across. Thanks