Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2023, 11:38 AM
Athena_4537 Athena_4537 is offline Execute a function stored in text format Windows 10 Execute a function stored in text format Office 2021
Novice
Execute a function stored in text format
 
Join Date: Mar 2023
Posts: 1
Athena_4537 is on a distinguished road
Default 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.
Reply With Quote
Reply

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
Execute a function stored in text format Changing a spreadsheet from # stored as text to stored as #? markg2 Excel 11 02-10-2017 08:54 AM
Execute a function stored in text format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft