t******a
发帖数: 30 | 1 This could be silly, but there is some formula/function in a cell that
puzzles me.
The formula is something like:
{=SUM(IF(ISNUMBER($B1864:$F1864),TRANSPOSE('TEMPLATE - Regression'!$I$20:$I$
24)*($B1864:$F1864),0))+'TEMPLATE - Regression'!$I$19}
The calculation itself is simple, it is a sum of product after transposing
some data. But what is that brackets doing there? I mean the {} at the
beginning and end. The results change if i delete the {}.
Thanks! |
|
