Need a book? Engineering books recommendations...

# Excel equations *was Calculation Software

• To: seaint(--nospam--at)seaint.org
• Subject: Excel equations *was Calculation Software
• From: Jim Wilson <wilsonengineers(--nospam--at)yahoo.com>
• Date: Tue, 13 Jul 2004 20:20:14 -0700 (PDT)

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
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********

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