IF logic formula

  • Thread starter Thread starter rwfster
  • Start date Start date
R

rwfster

Is there a formula that would allow the following: the entry of 6 variables
(a, b, c, , 1, 2, 3) into cells A1 through A6 as either single entries
(a..b..c..etc) or multiple entries with a maximum of 3 variables
(ab..ac3..etc) that will result in an "X" inserted into cell A12
 
Is there a formula that would allow the following:
 the entry of 6 variables (a, b, c, , 1, 2, 3) into
cells A1 through A6 as either single entries
(a..b..c..etc) or multiple entries with a maximum
of 3 variables (ab..ac3..etc) that will result in
an "X" inserted into cell A12
Click to expand...

Your requirement is unclear to me. But perhaps the following paradigm
will lead you to a usable solution.

Suppose you have the following VBA function:

Function foobar(Optional flag)
If IsMissing(flag) Then
foobar = Array("a", "b", "c", "1", "2", "3")
Else
foobar = Array("ab", "c1", "23", "X", "X", "X")
End If
End Function

Then if you select 6 cells in a row, you can enter the following array
formula (commit with ctrl-shift-Enter, not simply Enter):

=foobar()

or

=foobar(1)

Note: If you would like FOOBAR to return a column of cells, use
Application.Transpose(Array(...)). Or simply call =transpose(foobar
()), again as an array formula.
 
Back
Top