What does this formula say?

[GN0001]

(G6="")+(INDEX(d,,G7)=G6)


Many thanks,

Guity

 

[Hui]

if(G6="")+(INDEX(d,,G7)=G6)

if G6= nothing then 1 else 0

+

if the value in Range d, 1st row column G7 = G6 then 1 else 0

 

[GN0001]

Hui,


I can't put together why you describe this formula by "if"? It is a plus sign. I Understand that INDEX(d,,G7)=Index(d,1,4) is equal to " ". Since the intersection of first row and column 4 is nothing.


I understand you equal the result of index function to G6, which is " " as well.


I understand that G6=" "

But how can you conclude that if G6 is nothing then 1 else 0?


Sorry for this.

Guity

 

[Hui]

Guity

Just because it doesn't say If, doesn't mean that not what it is doing


open a new workbook

in D2 put a value, any value

in D3 =D2=1

D3 will show False if D2 has any value except 1

If D2 has 1 D3 will show True

 

[GN0001]

Hui,


Now I can understand what you say,


Look at this scenario:


If the G6 has a value like 5 and the result of (INDEX(d,,G7)=G6) is false since the intersection of first row and column 4 has a value other than 5. Then the result of "G6" +

(INDEX(d,,G7)=G6) will be 5. Since G6 is 5 and Index(d,, G7)=G6 is false equal to zero.


Is this right?

Guity

 

[Hui]

Not quite


=(G6="")+(INDEX(d,,G7)=G6)


If G6 has a value of 5

(G6="") will be False

and


(INDEX(d,,G7)=G6)

will be True if The Value of the First Row, Column G7 in Named Range "d" is equal to the value in G6 (5 in this case)