Forum Discussion

a7024782's avatar
a7024782
Brass Contributor
Jun 11, 2022
Solved

Actualizar una formula con el valor de una celda

Saludos, me gustaría plantear lo siguiente: es posible actualizar una formula con el valor de una celda? Por ejemplo: si el la celda A100 tengo la formula Suma(A1:A99) y el la celda B1 tengo A10:A90...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 11, 2022

    a7024782 

    =SUM(INDIRECT(B1))
=SUMA(INDIRECTO(B1))

    You can try this formula.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 11, 2022

a7024782 

There is an old XLM function EVALUATE that can be used within a defined name and works on Windows machines.

= SUM( Evaluateλ(formula) )

Evaluateλ 
= LAMBDA(f, EVALUATE(f))

Here I have assumed the name 'formula' is simply a range reference, but it could be text representing the function SUM( ) as well as the range, in which case the wrapping SUM is redundant.