Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Excel Subscripts

[Subject Prev][Subject Next][Thread Prev][Thread Next]

The dynamic gust factor program I sent to you when we worked on the Sarnia project has a solution to this problem. If you revisit that program you will find that entering 1, 2, or 3, for "TERRAIN" in the left hand side and a value for "K" is calculated accordingly. If this is what you are looking for it shouldn't be too hard to adapt it for your use.

For those not privy to our past communication, it's simply an "if statement" in F7; I.E. (If B12=1, xxx, If B12=2, yyy, If B12=3, zzz).

I don't know if that's what Gary is looking for or not. If so, that is a possible solution.



----- Original Message ----- From: "Gary L. Hodgson and Assoc." <design(--nospam--at)>
To: <seaint-seaosc(--nospam--at)>
Sent: Friday, August 02, 2013 1:00 PM
Subject: [SEAINT-SEAOSC] Excel Subscripts


Do any of the resident Excel experts here know how to append a calculated number to an alphanumeric character as a subscript? For example, a wind load is calculated for 3 different conditions so that there are 3 different answers to be appended to W as a subscript.


Post your message to the list by sending it to: SEAINT-SEAOSC(--nospam--at)

The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:

To contact the list owner, send your message to:

Sponsored By: Pacific Structural & Forensic Engineers Group, Inc. (PSFEG)

To unsubscribe, switch to/from digest, get on/off vacation, or change your email address, click here.