Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
Hi,
does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote:
Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
Hi Ron,
thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
This does the same
Function eval(str) Application.Volatile eval = Evaluate(str) End Function -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
On Tue, 1 Mar 2005 15:24:59 +0100, "Jos Vens" wrote:
Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos I believe Longre's add-in is only available in French and English. --ron |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
Thanks a lot for your help. I thought EVAL was a build-in function of
Excel. Now I see it is user defined, so I guess it must be a lot slower than Excel's build-in functions (I have 10x100 of those functions in my sheets) Jos "Bob Phillips" schreef in bericht ... This does the same Function eval(str) Application.Volatile eval = Evaluate(str) End Function -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
Hi Jos,
EVAL still uses the built-in Evaluate function. You just have the "overhead" of 1000 "wrappers". That will cost you a fraction of a second for which you need almost the width of a screen to display. You will not be able to notice. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Jos Vens" wrote in message ... Thanks a lot for your help. I thought EVAL was a build-in function of Excel. Now I see it is user defined, so I guess it must be a lot slower than Excel's build-in functions (I have 10x100 of those functions in my sheets) Jos "Bob Phillips" schreef in bericht ... This does the same Function eval(str) Application.Volatile eval = Evaluate(str) End Function -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
A lot slower yes, but a mere 1000 is almost instantaneous.
-- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Thanks a lot for your help. I thought EVAL was a build-in function of Excel. Now I see it is user defined, so I guess it must be a lot slower than Excel's build-in functions (I have 10x100 of those functions in my sheets) Jos "Bob Phillips" schreef in bericht ... This does the same Function eval(str) Application.Volatile eval = Evaluate(str) End Function -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a string in a formula
Thank you all for your time and effort to convince me!
Jos "Bob Phillips" schreef in bericht ... A lot slower yes, but a mere 1000 is almost instantaneous. -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Thanks a lot for your help. I thought EVAL was a build-in function of Excel. Now I see it is user defined, so I guess it must be a lot slower than Excel's build-in functions (I have 10x100 of those functions in my sheets) Jos "Bob Phillips" schreef in bericht ... This does the same Function eval(str) Application.Volatile eval = Evaluate(str) End Function -- HTH RP (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Hi Ron, thanks, but I can't find the dutch translation of EVAL. How can I find it? Jos "Ron Rosenfeld" schreef in bericht ... On Tue, 1 Mar 2005 13:59:40 +0100, "Jos Vens" wrote: Hi, does someone know if it's possible and how it can be done to use a string in formula like this cell A1 contains Average cell B1 contains =A1(C1:F1) which is the equivalent of =AVERAGE(C1:F1) thanks Jos Vens Download MOREFUNC.XLL from http://xcell05.free.fr/ and use the EVAL function. It accepts strings so, in your instance, the function would read: =EVAL(A1&"(C1:F1)") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
String Formula | Excel Worksheet Functions | |||
IF formula string | Excel Worksheet Functions | |||
Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) | |||
Create a formula into a String then assign string to a cell | Excel Programming |