Need a book? Engineering books recommendations...

# RE: Excel equations *was Calculation Software

• To: seaint(--nospam--at)seaint.org
• Subject: RE: Excel equations *was Calculation Software
• From: Kevin Below <kevinbelow(--nospam--at)videotron.ca>
• Date: Wed, 14 Jul 2004 20:47:35 -0400

Title: Message
The freeware disfor() function in Excel is great for showing the actual figures in a calculation.

The Disfor() function will convert any referenced address of the formula in the cell to their respective value, and display the formula with the respective values. If value in the displayed formula contain 'Empty', 'Null', 'Error' or 'String', then the formula contains non numeric values or invalid reference.

http://www.geocities.com/SiliconValley/Hills/1829/VBA/disfor.htm

Kevin Below, ing., Ph.D.

GÉNÉCOR CIVIL INC.

290, rue Seigneuriale

Beauport, (Québec) G1C 3P8

Tél. : (418) 660-6969 poste 272

Fax : (418) 660-6463

-----Original Message-----
From: Jim Wilson [mailto:wilsonengineers(--nospam--at)yahoo.com]
Sent: 13-Jul-04 23:20
To: seaint(--nospam--at)seaint.org
Subject: Excel equations *was Calculation Software

You can make excel print out formulas with the actual calculated numbers in them as follows:

say you want the equation x=y/z to show with the actual numbers where

x is in cell b1 = 10
y is in cell b2 = 20
z is in cell b3 = 2

Type the equation into a cell as =b1&" lbs = "&b2&" lbs / "&b3

The cell will automatically look like "10 lbs = 20 lbs / 2"  Fractions and long equations can be created using multiple cells and cell formatting for division lines, etc.

Yeah, its a little pain in the *&!, and you have to duplicate the formula to get the actual result to print out, but it looks pretty sharp once set.

Jim Wilson, PE
wilsonengineers(--nospam--at)yahoo.com
Stroudsburg, PA

Christopher Wright <chrisw(--nospam--at)skypoint.com> wrote:
>But is there a way to show the name variables in Excel for ONLY ONE
>CELL and not the entire sheet?
I don't know of a way to display the formula in a single cell as a text
string. I've often thought it would be nice, but the only way for sure is
to copy the formula without the equals sign and paste it where you want
to see it.

>On top of it all I on Mac platform!
Another enlightened soul...

>I "discovered" the concatination and round functions in Excel, where you get
>the contents of several cells to show up in one cell.
Excel is loaded with cool stuff like this; the problem is that it takes
forever to learn it all. You can format cells with your desired units if
you like, so you can operate on the number and still have the results
show up formatted with text characters.

Christopher Wright P.E. |"They couldn't hit an elephant at
chrisw(--nospam--at)skypoint.com | this distance" (last words of Gen.
___________________________| John Sedgwick, Spotsylvania 1864)
http://www.skypoint.com/~chrisw

******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
* http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 2004-07-09

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 2004-07-12