Concatenating strings will leave you with strings--not formulas that will be
evaluated.

But it kind of looks like this would work:

=if($b1000<1234,min(indirect(c1000)),max(indirect( c1000)))



p6er wrote:

I have a cell, which generates a certain range. I now want to use this
range in a formula, which is also generated.

E.g.:

cell C1000 contains the text $A$1:$A$1000
cell D1000 should now either calculate MAX or MIN via a
=IF($B$1000<1234,
MAX(cell("contents",$C$1000),MIN(cell("contents",$ C$1000))

As I got a #VALUE error, I tried to minimize the complexity in D1000 to
see whether it works at all:
=MAX(cell("contents",$C$1000))

but I still get the error. If I replace the cell funciton with the
actual range, it works fine, so the range is correct. Even usage of the
address function within the MAX function doesn't give me a result.

I then assigned D1000 the *text* of the complete MAX function via
=CONCATENATE("=MAX(",TEXT(T3,"$A$0"),":",TEXT(U3," $A$0"),")")

with T3 containing a 2 and U3 containing a 1000. But now I don't know,
how to *execute * this command

Any ideas how to dynamically generate functions.

Thanks,
Peter

--
p6er
------------------------------------------------------------------------
p6er's Profile: http://www.excelforum.com/member.php...o&userid=28571
View this thread: http://www.excelforum.com/showthread...hreadid=482348

--

Dave Peterson