ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulas for dividing in Excell (https://www.excelbanter.com/excel-discussion-misc-queries/166491-formulas-dividing-excell.html)

jimmy

Formulas for dividing in Excell
 
Hi,
I am looking for a formula to devide two numbers. They have adission, ect...
but could not find division.
--
Jimmy

Sandy Mann

Formulas for dividing in Excell
 
Division in Excel is done with the forward slash symbol:

=45/9

or with Cell references:

=A1/B1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jimmy" wrote in message
...
Hi,
I am looking for a formula to devide two numbers. They have adission,
ect...
but could not find division.
--
Jimmy




Gord Dibben

Formulas for dividing in Excell
 
Copied directly from Help on "division"

Divide numbers

Type =10/5 in a cell to display the result 2.

"snipped the irrelevant parts"

A
Data
15,000
12
Formula Description (Result)
=A2/A3 Divides 15,000 by 12 (1250)


Gord Dibben MS Excel MVP

On Sat, 17 Nov 2007 14:31:02 -0800, Jimmy
wrote:

Hi,
I am looking for a formula to devide two numbers. They have adission, ect...
but could not find division.




All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com