Excel formula What does this mean?

IF ((1,0), A3:A123 & C3:C123 & E3:E123, D3:D123) to explain how ah

this title mean Is:

if the value for (1,0), A3:A123 & C3:C123 & E3:E123 value (that is, three of the range and logic);
Otherwise, the calculation of D3:D123 Range.

Cite an example:

IF (A2 <= 30, SUM (C2:C18 ),””)
if the above figure is less than equal to 30, the calculation range B5:B15 and otherwise return to empty text ( “”).To determine whether or not a condition to meet, if the value of a return to the meet, is not satisfied with the return of value to another; A3:A123 from A3 to A123 ….For example, there are figures on the condition that the 100-200, 100-200 of the show will be R, is not within the scope of the show T, of course, R, T is a set of formulas that …the role of Yes, a list will be \ C out \ E data into a data connection, then D-disaggregated data as a new array of data in the second set, a new two-dimensional array;

== ===================
Excel Technology Group, the exchange of group 1 # 34748522 2 # 17127559 3 # 45532100 4 # 15708475
-tang remote classroom school.jacktown.Church-net
Forum bbs.jacktown.net