Thread: Test 2 numbers
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Test 2 numbers
On Sat, 7 Feb 2009 04:38:01 -0800, Mike H
wrote:

=(A1=B1)*1+1

The *1 seems to be superfluous.

=(A1=B1)+1



--ron
Reply With QuoteReply With Quote