Hi,
I have
A --------- B --------- C --------- D ------------ E
Name1 --- Name2 --- Address1 --- Address2 --------- Result
A ---------- B -------- 1 Street ------ 1 Street -------- 1
A ----------- 0 --------- 1 Street ------ 0 --------- 1
A ---------- B -------- 1 Street ------ 2 Street --------- 2
When Address1 & Address2 are same i would like the result column to say '1'
When Address2 is '0' I would like the If function to always say '1' in result column
When Address1 & Adress2 are different then I would like the If function to say '2' in result column, is it possible ?
When I use the following statement I always get values in minus. Can someone please assist ? Sorry for the trouble as I am a noob in excel - ta
IF(C3=D3,1,0)-IF(D3=0,1,2)
Bookmarks