Help with arrays

[ringerhb]

I have an array of 3 numbers that are dependent upon a formula. The formulas one day might make an array of (0,3,7). I want to use the small formula on these three numbers. so I will say =small(a1:a3,1). BUT, I don't like having to have the 0,3,and 7 on my excel spread sheet. It is too messy. I would like to be able to enter the a1 a2 and a3 formulas into my small formula but I don't know how. Something like .... =small(formula1,formula2,formula3,1)
Is this possible? Thanks!

 

[Jonmo1]

Welcome to the board...

What are the formulas you have in A1 A2 and A3?


don't think it can be done exactly as you're thinking.
But depending on what those formulas are, there's likely some kind of
=SMALL(IF(...
type of formula that will work.

 

[barry houdini]

Try using CHOOSE function

=SMALL(CHOOSE({1,2,3},formula1,formula2,formula3),1)

don't include = for the 3 formulas......

 

[Aladin Akyurek]

I have an array of 3 numbers that are dependent upon a formula. The formulas one day might make an array of (0,3,7). I want to use the small formula on these three numbers. so I will say =small(a1:a3,1). BUT, I don't like having to have the 0,3,and 7 on my excel spread sheet. It is too messy. I would like to be able to enter the a1 a2 and a3 formulas into my small formula but I don't know how. Something like .... =small(formula1,formula2,formula3,1)
Is this possible? Thanks!

All that needs some clarification...

What you have...

=small(formula1,formula2,formula3,1)

can be read something like:

=SMALL((SUM(A1:C1),PRODUCT(E2,F2),3),1)

which is equivalent to:

=MIN(SUM(A1:C1),PRODUCT(E2,F2),3)