| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Division of all cells by a common number
Input 25 into a blank cell somewhere, then copy cell. Select your data,
right-click. Paste special, divide. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Icegirl" wrote: Hi, I have the following data: Series A 124 34 946 576 I would like to divide each cell in the above column by 25, and have the number returned in the same cell without doing so indvidually. How do I manage that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| division with blank cells | Excel Discussion (Misc queries) | |||
| Division on a totaled number | New Users to Excel | |||
| Range of cells and division formula | Excel Discussion (Misc queries) | |||
| Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
| How do I multipy a range of cells by a common number? | Excel Worksheet Functions | |||
Hybrid Mode
