{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

excel functions v8

# excel functions v8 - Spreadsheet Functions CEE3804 Computer...

This preview shows pages 1–11. Sign up to view the full content.

Spreadsheet Functions CEE3804: Computer Applications for Civil and Environmental Engineers

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

View Full Document
Spring 2007 CEE 3804 2 1. Topics to be Covered Understanding Excel’s Error Codes Auditing Worksheet Formulas Using Excel’s Built-in Functions Lookup Functions Financial Functions Date/Time Functions Financial Functions
Spring 2007 CEE 3804 3 1. Function Basics Formula results depend on the operator sequencing and precedence: (2+6)/2 = 4 2+6/2 = 5 Excel sequence in operations: left to right: parentheses exponential calculations multiplication and division addition and subtraction

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

View Full Document
Spring 2007 CEE 3804 4 1. Function Basics b. Reference Operators Excel uses three reference operators: the colon: cells between and including two cell references e.g. A1:A5 refers to A1, A2, A3, A4, and A5 the comma: indicates the union of two ranges e.g. A1:A3,B4,B6:B7 refers to A1, A2, A3, B4, B6, and B7 the space: indicates the intersection of two ranges C1:C5 B3:G3 refers to cell C3
Spring 2007 CEE 3804 5 1. Function Basics c. Creating Names and Using Text Define range including row and column names: Insert/Name/Create Creates names for rows and columns A3: Nice B3: Person C3: A3&” “&B3 gives Nice Person

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

View Full Document
Spring 2007 CEE 3804 6 1. Editing Formulas a. Overview To edit a formula: press F2 or double-click on the cell dependent cell references are color coded to simplify editing can dependent cell references with the mouse Can edit formula in the formula palette result will be updated as the formula is edited
Spring 2007 CEE 3804 7 2. Editing Formulas b. Decoding Error Values - Overview Excel errors begin with a “#” sign: #DIV/0 #N/A #NAME? #NUM! #REF! #VALUE! #NULL!

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

View Full Document
Spring 2007 CEE 3804 8 2. Editing Formulas c. Decoding Error Values - #DIV/0 and #N/A #DIV/0: divide-by-zero error indicates that the denominator evaluates to zero Note: empty cells evaluate to zero #N/A: Not available error varies depending on formula: lookup function: no value available data: data not yet available charting features ignore #N/A can include in a formula - NA(): Example: if(B7=0, NA() ,B7)
Spring 2007 CEE 3804 9 2. Editing Formulas d. Decoding Error Values - #NAME? and #NUM! #NAME?: Name Error Excel cannot evaluate a defined name used in formula #NUM!: Number Error Number cannot be interpreted: too small or too big does not exist

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

View Full Document
Spring 2007 CEE 3804 10 2. Editing Formulas e. Decoding Error Values - #REF!, #VALUE! and #NULL! #REF!: Reference Error
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 60

excel functions v8 - Spreadsheet Functions CEE3804 Computer...

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

View Full Document
Ask a homework question - tutors are online