Multiplying and Dividing Values
Apply the asterisk and slash operators to scale and split numbers.
Two New Operators
Spreadsheets skip the school symbols. Multiply with the asterisk * (above the 8 key) and divide with the forward slash /.
=6*7Simple Multiplication
Put an asterisk between numbers to multiply. The formula below shows 42. You can chain more too: =2*3*4 gives 24.
=6*7All lessons in this course
- Why Every Formula Starts With Equals
- Adding and Subtracting in a Cell
- Multiplying and Dividing Values
- Order of Operations in Formulas