| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
meaning of : IF(Switch; Average(array A, array B); array A)
I do not understand the use of 'Switch' at the place of the logical test ...
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
meaning of : IF(Switch; Average(array A, array B); array A)
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DXAT" wrote in message ... I do not understand the use of 'Switch' at the place of the logical test ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Display an array of references | Excel Worksheet Functions | |||
| defintion of array function | Excel Discussion (Misc queries) | |||
| Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
