1 / 12

Excel Functions for Basic Math Operations

Learn how to use Excel functions for basic math operations like addition, subtraction, multiplication, and division. Explore formulas, selecting ranges, basic math functions, trigonometry functions, logical operators, and time & date functions. Understand the application of these functions in engineering computations.

sclaudia
Download Presentation

Excel Functions for Basic Math Operations

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ME 142Engineering Computation I Excel Functions

  2. Basic Math Operations • Basic Math Operators + Addition - Subtraction / Division * Multiplication ^ Exponent ( ) Parenthesis, as need, follows algebraic precedence

  3. Finding Functions • Formula Ribbon

  4. Finding Functions • Insert Function button

  5. Sum and AutoSum • Sum • =SUM(range) • AutoSum • Note auto-selection of row/column

  6. Selecting Ranges • Use mouse to drag from top to bottom, or side to side • Select rectangular area by dragging to diagonal corners or using [shift] key • Select disconnected columns/rows by using [ctrl] key • Select a long row/column by using [ctrl][shift][end] key sequence

  7. Basic Math Functions • SQRT(x)-returns the square root of a number • ABS(x)-returns the absolute value of a number • MAX(range)- returns the largest number in a set of values • MIN(range)-returns the smallest number in a set of values • COUNT(range)-counts the number of cells in a range that contain numbers • COUNTA(range)-counts the number of cells in a range that are not empty • STDEV(range)-estimates the standard deviation based on a sample

  8. Trigonometry Functions • Excel uses Radians by default in all trig functions • Use RADIANS and DEGREES functions to convert • RADIANS(x)-converts degrees to radians where x is given in degrees • DEGREES(x)-converts radians to degrees where x is given in radians

  9. Trigonometry Functions • SIN(x) - returns the sine of an angle where x is in given in radians • COS(x) - returns the cosine of an angle where x is given in radians • TAN(x) - returns the tangent of an angle where x is given in radians • ASIN(x) - returns the arcsine of a number in radians, in the range –pi/2 to pi/2 • ACOS(x) - returns the arccosine of a number in radians, in the range 0 to pi • ATAN(x) -returns the arctangent of a number in radians, in the range –pi/2 to pi/2

  10. Logical Operators • IF(logical test, value if true, value if false) -checks if a condition is met, returns one value if True, another value if False • AND(logical1,logical2,…) -returns True if all arguments are true, otherwise returns False • OR(logical1,logical2,…) -returns True if any argument is true, returns False only if all arguments are False • NOT(logical) -returns True if argument is False, returns False if argument is True

  11. Logical Operators

  12. Time & Date Functions • TODAY() -returns the current date • NOW() -returns the current date and time • Format of the date/time can be modified

More Related