Re: Evaluation of a string...

Article View: comp.apps.spreadsheets

Article #3

Back to comp.apps.spreadsheets Previous Next

From: Peter Weyzen
Date: Tue, 27 Oct 1992 20:43

18 lines
1025 bytes

>I want to be able to enter in a cell, a STRING that represents
>a valid function, i.e. MIN(3,5), and in another cell to have the result
>of this function (here 3). 
>
>In other words I am looking for a formula that takes as input a string,
>and evaluates it.
>
The solution for this is simple in Quattro/QuattroWin/1-2-3/etc...

Enter formula in A1:
In A2: @@(+"@"&A1)

@@() takes a string input and treats the string as a formula.


-- 
Peter Weyzen      /  "Some day my log will have
phw@borland.com  /    something to say" -Log Lady

Technical Details

Message-ID: <1992Oct27.204335.24763@genghis.borland.com>

Path: arc1-ca.pugleaf.net!sparky!uunet!ukma!usenet.ins.cwru.edu!agate!ames!decwrl!borland.com!phw

References: <bluguras.719863657@news.forth.gr>

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!ukma!usenet.ins.cwru.edu!agate!ames!decwrl!borland.com!phw
From: phw@genghis.borland.com (Peter Weyzen)
Subject: Re: Evaluation of a string...
Message-ID: <1992Oct27.204335.24763@genghis.borland.com>
Originator: phw@genghis.borland.com
Sender: news@borland.com (News Admin)
Organization: Borland International
References: <bluguras.719863657@news.forth.gr>
Date: Tue, 27 Oct 1992 20:43:35 GMT
Lines: 18

Reply to Parent Message