opprecedence

opprecedence - $column$row reference Reference to assigned...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Geology 351 GeoMathematics Excel Formulas and Variables In the quadratics and Settling Velocities lab discussion (see last week’s handout) there is a discussion of the solution for quadratic A) 3x 2 -x -5. Below, three separate approaches to setting up the Excel formulas for B and C are illustrated. One of them yields the incorrect result. Why? Use the Excel file Quad.xls on your common drive to explore this question. General equation: ax 2 + bx + c Approach 1: Coefficients are explicitly specified in the Excel formula. The following two approaches use constants in the equation whose cell locations are referenced in the Excel formula. The two approaches employ a $column$row approach and reference to variable name noted in the formula.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $column$row reference Reference to assigned variable name Take a look at the formula and see if you can figure out why one of the methods for writing the formula yields an incorrect result. What is the explanation? ________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ Geol 351 GeoMath The order in which Excel operations are performed in Excel formulas is an important issue to keep in mind when performing even very basic computations. The following note comes from the Excel Help files....
View Full Document

Page1 / 3

opprecedence - $column$row reference Reference to assigned...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online