meaning of : IF(Switch; Average(array A, array B); array A)

B

Bernard Liengme

Maybe it refers to a named cell.
For example =IF(A1,TRUE,FALSE) will return TRUE for any non-zero number in
A1
So if A1 is named Switch, then =IF(Switch,TRUE,FALSE) will behave the same
way
Alternatively Switch could be a named formula but the logic is the same
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding if to Average If Array function 5
LINEST multiple known_x's separated arrays 5
Shape Arrays VBA 0
UPDATED - How to multiply arrays and get the largest number in theresulting array ? 4
Mapping integers to strings 5
How to multiply arrays and get the largest number in the resultingarray ? 11
Whats wrong with this array formula 7
Formulas with-an an array 2

Top