What i need is to see the values, these are the output of the formulae (the
feasible size numbers for the project) how could i do this?? thanks again

"Bob Phillips" wrote:

It returns an array, which is what you aid you wanted. You need to do
something with that array, embed it in another formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darren1o1" wrote in message
...
The value in the box then comes up as false.

"Bob Phillips" wrote:

=IF(A1:A100="Feasible",B1:B100)

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darren1o1" wrote in message
...
I need a function to check a Column of data and check if it is
"Feasible"
or
"Unfeasible". In the next column of data the is measurements. I need
to
get
the measurements of the "Feasible" data into of an array.
Eg.
Column a = Feasible?
Column b = Inductance (Tesla)

Feasible? Inductance (Tesla)
Feasible 1,17621E-06
Feasible 1,59844E-06
Feasible 2,05083E-06
Feasible 2,5937E-06
Feasible 3,16673E-06


Should end up with the inductance values in an array if they are
feasible.
Thanks