Cell Formula written in c # for EXCEL: objCells [27, 19]. Formula="=D1002 * 0.5";
My question is, if a cell in the EXCEL formula involves the array form, my formula how to write?
This writing must be wrong:
ObjCells [28, 23] Formula="=INDEX (LINEST (A102: INDIRECT (" a \ "& amp; (SMALL (IF (A2: A1002=U30 and ROW (2:10 02)), 1)), 1), B102: INDIRECT (\ "b " & amp; (SMALL (IF (A2: A1002=U30 and ROW (2:10 02)), 1)), 1) ^ (Y26: AD26), TRUE, FALSE), 1);"
Arrays formula: the formula for the multiple values of one or more sets, and return one or more as a result, the formula of array enclosed in curly braces ({}), press Ctrl + Shift + Enter formula, can input array) in the form of input,
CodePudding user response:
Range. FormulaArray