Skip to content

Instantly share code, notes, and snippets.

@dfkaye

dfkaye/spreadsheet-math.md

Last active February 14, 2021 23:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dfkaye/0c2cc6f618767e991b72eae6f73d1e9d to your computer and use it in GitHub Desktop.
Save dfkaye/0c2cc6f618767e991b72eae6f73d1e9d to your computer and use it in GitHub Desktop.
Download ZIP
Math functions and operators in spreadsheets via spreadsheetclass.com
Raw
spreadsheet-math.md

Math in spreadsheets

Notes copied verbatim from Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square by Corey Bustos.

Mathematical spreadsheet operators

  • Plus sign (+) ~ Addition
  • Minus sign (-) ~ Subtraction
  • Asterisk (*) ~ Multiplication
  • Forward Slash (/) ~ Division
  • Carrot (^) ~ Exponent

Mathematical spreadsheet functions

  • =ADD( ~ Addition
  • =MINUS( ~ Subtraction
  • =MULTIPLY( ~ Multiplication
  • =DIVIDE( ~ Division
  • =SUM( ~ Summing
  • =POWER( ~ Exponent / Power
  • =SQRT( ~ Square Root

Ranges

Example: =SUM(A1:A7) - adds values in column A from row 1 through row 7.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment