×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

returning to the "Display values behind formula" in excel

returning to the "Display values behind formula" in excel

returning to the "Display values behind formula" in excel

(OP)
returning to the "Display values behind formula" in the faqs:

"Display values behind formula.
Download excellent VBA function disfor() from http://www.geocities.com/SiliconValley/Hills/1829/... The formula will look like actual handwriting, e.g. (5+6.3)/3."

The link has expired. Is there a working link?
Is there an alternative solution?

regards
ykantor1

RE: returning to the "Display values behind formula" in excel

(OP)
Hi
While googling, it was found at http://www.geocities.ws/lalesyah/Download/index.html but have not tried to use it.
Is there a way to verify that it is not a malware?

Is there an alternative solution?

regards

ykantor

RE: returning to the "Display values behind formula" in excel

I found it at:
http://www.reocities.com/SiliconValley/Hills/1829/...
with the download at:
http://www.reocities.com/SiliconValley/Hills/1829/...

I downloaded it and it doesn't seem to be malware (from a quick look)

Unfortunately it isn't open source.

You might find my Eval2 spreadsheet useful; here:
http://newtonexcelbach.wordpress.com/2012/10/01/da...

It doesn't do exactly what you asked for (which from a quick look doesn't seem to be a simple job), but what it does do is if you have a two columns with variable names, and associated values:
a 1
b 2
c 3
and a function entered as text:
= a + b + c
then it allows you to either evaluate the function, or display the individual values:
= 1 + 2 + 3

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: returning to the "Display values behind formula" in excel

(OP)
thank you Doug
It is OK and working.

Just for my curiosity- why "doesn't seem to be a simple job" ?

One may use:

Public Function DisplayFormula(rng As Range) As String
Displayformula = rng.Formula
End Function

and generate the formula with cell addresses and operators. The next step is to substitute the cell values instead of the cell addresses. Is that the problem?

(it is a pity that for me, it is a problem)

ykantor

RE: returning to the "Display values behind formula" in excel

Nothing is ever a problem to someone who hasn't done it yet; we just had a supplier finding that they couldn't actually do what they proposed.

Writing a robust parser is not a simple task. What if I used aliases for the cell addresses? Note that this macro does allow aliases, i.e., you can make a = z/y + x*z with the appropriate alias definitions, and the macro will still return the correct values.

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers

RE: returning to the "Display values behind formula" in excel

Quote:

The next step is to substitute the cell values instead of the cell addresses. Is that the problem?

Yes, extracting cell addresses and named ranges from a text string is not that straightforward.

Does the disfor function work OK? It seemed to, but I only had a quick look.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: returning to the "Display values behind formula" in excel

(OP)
IRstuff - A limited function is still valuable for me ( and presumably for other users as well). i.e no aliases, no named ranges, just plain cell addresses.

Doug - the DISFOR function works fine.

regards

ykantor

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources