What's the difference between

A1 on worksheet 2 not equal to A1 on worksheet 1 i.e. new

and

if A1 on worksheet 1 does not equal A1 on worksheet 2 i.e. disposed

they seem the same condition to me.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"K" wrote in message
...
I need a formula to identify if a cell is missing on either worksheet or
if
they are the same. How do you write a formula that states the following:

If A1 on worksheet 2 = A1 on worksheet 1 then "current" if not then "new"
AND if A1 on worksheet 1 does not equal A1 on worksheet 2 then "disposed"