Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Division | Excel Worksheet Functions | |||
HOW DO I DO SIMPLE DIVISION? | Excel Worksheet Functions | |||
Division help? | Excel Discussion (Misc queries) | |||
Division help? | Excel Discussion (Misc queries) | |||
How do you create formulas in pivot table eg simple division? | Excel Worksheet Functions |