Create calc formula with INDIRECT and CONCATENATE

Hi!

I would like to create a variable formula. As an example, I have the following values:

Cell A1: =
Cell A2: *
Cell A3: 2
Cell A4: 3

But the formula =INDIRECT(CONCATENATE(A1;A3;A2;A4)) does not work!?

Any idea? Or is there any other solution to create variable calc formulas, based on different cell values?

Thanks,
FixandFoxi

Hi FixantFori,

Indirect converts text to address reference. What is the output you require from the above example?

Regards,
Sindhu

Hi Sindhu,

Thanks for your feedback. The above is just an example. Finally I have a complex SUMPRODUCT formula with different named cell areas. Based on dropdown entries (by the user), the formula string should be amended. Is there any way to do that?

Thanks!

I couldn't understand your requirement. If you can share a workbook with dummy data, I can understand it better.

Is there any way to do the following calculation, based on cells only:

=CONCATENATE(A1;A3;A2;A4)

The above formula gives the following text string: =2*3

The result should be 6 and not the text.

Thanks!

I think you can try Evaulate function for your requirement. http://www.vertex42.com/ExcelArticle...-function.html

EXCELLENT!!! That works!!! Many, many, thanks Sindhus!!!