Comments on: How to Divide in Google Sheets (Numbers, Cells, or Columns) https://spreadsheetpoint.com/divide-google-sheets/ Google Sheets Tips & Tutorials Fri, 25 Oct 2024 11:14:04 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jmarkus https://spreadsheetpoint.com/divide-google-sheets/#comment-17044 Fri, 25 Oct 2024 11:14:04 +0000 https://spreadsheetpoint.com/?p=1779#comment-17044 In reply to m.

Great question. Yes, you can use =DIVIDE(A1, 12) and it should work just fine.

]]> By: m https://spreadsheetpoint.com/divide-google-sheets/#comment-17038 Thu, 24 Oct 2024 19:58:00 +0000 https://spreadsheetpoint.com/?p=1779#comment-17038 Is there anyway you can use the function without having a cell for the divisor? If i have a cell with a total but I want to divide it by 12 months, do i have to create a cell that says 12 for the function to work? Or can i =DIVIDE(Cell#/12) some how??

]]> By: jmarkus https://spreadsheetpoint.com/divide-google-sheets/#comment-13594 Mon, 12 Feb 2024 13:18:48 +0000 https://spreadsheetpoint.com/?p=1779#comment-13594 In reply to Somn.

If one of the cells is showing #N/A, you won’t be able to use it as the numerator or denominator. The cell value must be a number.

]]> By: Somn https://spreadsheetpoint.com/divide-google-sheets/#comment-13576 Sat, 10 Feb 2024 07:49:12 +0000 https://spreadsheetpoint.com/?p=1779#comment-13576 What if one cell have the value #N/A

]]>