Some excel formulas are trying to understand and I like some stuff like SUMPRODUCT (- Left (...). .)
What is - doing? Naturally I feel like reducing but no document could be found on it.
Thank you.
Specifically:
on SUMPRODUCT () Not given consideration
Non-numerical entries give a comparison of a Boolean (TRUE / FALSE) value, which is non-numeric. XL automatically adds the Boolean value to numerical values (1/0, respectively) in arithmetic functions (for example, 0 + 0 = 1).
The most effective way to forcibly price the first operator, coercing -1/0 for the right / wrong, then refusing the value to re-apply it, such as, +1/0.
By using a double unary operator in the -1/0 values in a single unary operator (-) coerces correct / incorrect , we Again, forcibly values the values of 1/0 .
Comments
Post a Comment