Resolve cell references in worksheet function arguments

[Thomas]

Hi,

I'm searching for a way to resolve cell references in worksheet
functions.

Let's say cell A1 contains value 1 ,cell A2, named Input, contains
value 2
and cell B1 contains formula =max(A1;Input) I need a way to get
=max(1;2) or "1;2" (i.e. the cell reference resolved)

Any help greatly appriciated

tg

 

[Bernie Deitrick]

Thomas,

Try going into edit mode (F2) and then highlight each of the terms you want
resolved, and press F9. Pressing Enter will keep those changes, pressing
Esc will keep your formula.

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

I should have noted that if you have a multicell reference, you should
convert the whole reference at once, and not individually, or you will get
an error.

For example,
=max(A1;Input)
which to me would be =max(A1:Input)

If you resolve the A1 to 1 and Input to 2, then the actual formula becomes
=MAX(1:2)

or the max of rows one and two.

Instead, select the A1;Input, and it resolves to

=MAX({1;2})

or the maximum of the array of values 1 and 2.

HTH,
Bernie
MS Excel MVP