I should have mentioned that if you use DELTA and get a name error then

Tools|Addins and check the analysis toolpak

re-enter the formula

Mike

"Mike H" wrote:

Hi,

A couple of ways

=DELTA(A1,B1)+1

or

=(A1=B1)*1+1

Mike



"Dave" wrote:

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