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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top