=MAX(INDIRECT("A"&B1&":A"&B2))

HTH
--
AP

"istratos" a écrit
dans le message de
...

Hallo

My problem:
I have decimal numbers in column A, extending from Cell A1 to cell A100


In Cell B1 I type the number 10
And
In cell B2 I type the number 50

What do I have to type in Cell C1 to calculate the maximum value from
area A10 to A50?
Please consider that 10 and 50 are the numbers I typed on cell B1 and
B2.


--
istratos
------------------------------------------------------------------------
istratos's Profile:
http://www.excelforum.com/member.php...o&userid=33367
View this thread: http://www.excelforum.com/showthread...hreadid=532559