dear support,
I have a string variable that might look like
> a reference to a cell , eg A1
> a reference to a cell range, eg A1:B1
> a formula, eg CONCATENATE(A1;“hello”)
> a fixed value, eg whatever
is there a simple way to interprete the results.
> case #1 : it should return the value in that cell. This works with CalculateFormula
> case#2 : it should return an array with the values of the cells in the range. Does not work with CalculateFormula
> case #3 : is should return the result of the formula, does not work with CalculateFormula
> case #4 : does not work with CalculateFormula
thanks for your thoughts,
guido