Thread
:
Test 2 numbers
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
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 Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld