Posted to microsoft.public.excel.worksheet.functions
|
|
Test 2 numbers
You are welcome
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Ashish Mathur" wrote in message
...
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
|