#1
|
|||
|
|||
Execute a function stored in text format
Hello,
In an Excel sheet, I would like to introduce a function (in text format) which will then be retrieved to be applied to various cells, but with the contents of a cell (which will vary dynamically) via the LET function. For example: Function: x+x^(1/2) or sin(x+1) or 2x^3-3x^2+5*x-3 LET formula obtained by concatenation: LET(x, B40, x+x^(1/2)) or LET(x, B40, sin(x+1)) And then, to execute this function in different places, with B40 which will vary depending on the cell where LET is created: LET(x, C40, x+x^(1/2)) then LET(x, D40, x+x^(1/2)) But how to execute and calculate this function stored in text format? The function =LET(x, B40, x+x^(1/2)) used directly in a cell gives a result, but if the function (here x+x^(1/2)) changes, all the LETs need to be rewritten... While a dynamic composition allows you to have the right LET everywhere, but... how to execute it afterwards. The VBA function gives me errors 2015. I am open to any solution, even in VBA. Thank you in advance for your help. |
Tags |
function text execute |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge field mistakenly interpret text format as date format | alan6690 | Mail Merge | 0 | 09-02-2020 01:54 AM |
VBA format function | eduzs | Word VBA | 1 | 02-13-2019 07:38 PM |
Changing a spreadsheet from # stored as text to stored as #? | markg2 | Excel | 11 | 02-10-2017 08:54 AM |
Using Left function to format a range | USAOz | Excel | 4 | 09-10-2015 03:00 AM |
Change format of date when using Now function in VB code | Bondai | Excel Programming | 2 | 03-02-2012 05:09 PM |