Hi,

In cell C2, you can use the formula

=If(a1=b1,2,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave" wrote in message
...
Hello,

two number in (say) a1 & b1

In another cell If the numbers are different how can i get Excel to
return
1 or if the numbers are the same 2


d