Thursday 7 November 2019

How to Divide Numbers in Google Sheets

Google Sheets Header

Whether you need to divide static integers or data from two cells or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the quotient. Here’s how.

Using the DIVIDE Formula

Fire up your browser, head to Google Sheets, and open a spreadsheet.

Click on an empty cell and type =DIVIDE(<dividend>,<divisor>) into the cell or the formula entry field, replacing <dividend> and <divisor>with the two numbers you want to divide.

Note: The dividend is the number to be divided, and the divisor is the number to divide by.

Type "=DIVIDE(<dividend>,<divisor>)" into the cell, replacing <dividend> and <divisor> with the two numbers you want to divide. 

You can also use the data inside another cell. Instead of a number, type the cell number and Sheets will automatically put the integer from that cell in its place.

You can also reference other cell's data by typing in the cell number you want to use.

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

Read the remaining 13 paragraphs



from How-To Geek https://ift.tt/36ENq0Q

No comments:

Post a Comment