Using equations in Excel

From SubSurfWiki
Revision as of 14:21, 23 October 2013 by Matt (talk | contribs) (note about units)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Unless otherwise indicated, everything on this wiki uses SI units.

To use one of the equations in Excel, do the following:

  1. Make a note of the variables in the function, e.g. Vp, Vs and rho in this one:
    =rho*Vs^2*(3*Vp^2-4*Vs^2)/(Vp^2-Vs^2)
  2. Set up the sheet with your variables, for example:
    Excel function example.png
  3. Name the variables:
    • Select each one in turn and go to Insert > Name > Define...
    • Use the name that is used in the function, or remember that you must change the function to match what you choose
  4. Copy and paste the function into its own cell (B5 in the example above), making sure there are no leading spaces; it should evaluate immediately:
    Excel function example done.png

The example here is to compute Young's modulus in GPa.