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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do not understand the use of 'Switch' at the place of the logical test ...
 
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
 
You must log in or register to reply here.

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
Shape Arrays VBA 0
LINEST multiple known_x's separated arrays 5
Average array 5
Arrays and Averages 3
UPDATED - How to multiply arrays and get the largest number in theresulting array ? 4
Excel Wildcard in Excel array formula 0
Whats wrong with this array formula 7

Back
Top