ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Simple Division (https://www.excelbanter.com/new-users-excel/161492-simple-division.html)

Maurice

Simple Division
 
Have no experience with formulas but thought I could at least create a
division function. Have a number of bills I share. I just want to create a
cell that takes the value from the cell next to it and divide by four. Could
not find a simple division formula in excel 2003. Much thanks for any
assistance

RagDyeR

Simple Division
 
Say your individual bill total is in Column D, from D2 on down.

In E2, enter this formula:

=D2/4

Now click back in E2 to select it.

In the lower right hand corner of that selected cell you'll see a small
black square.
Hover your cursor over that square until it changes from a fat white cross
to a skinny black cross.
Then click and drag down as many rows as you think you'll need.
This *automatically* copies the formula for you, so that you don't have to
enter it yourself in each individual cell.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Maurice" wrote in message
...
Have no experience with formulas but thought I could at least create a
division function. Have a number of bills I share. I just want to create
a
cell that takes the value from the cell next to it and divide by four.
Could
not find a simple division formula in excel 2003. Much thanks for any
assistance





All times are GMT +1. The time now is 05:04 PM.

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