Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i have very little excel experience, i have a spreadsheet with a few large columns (of numbers) I need to divide each cells amount by 8. Is there a way to reference the cell itself and divide the original value by 8? Alternatively, but less useful would be if I can just do a divide by 8 on each value and lose the original value. There are too many cells to do each one individually I tried circular reference with iteration count of 1 but that didn't work. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Applying Formulas to a Range in a Worksheet | Excel Discussion (Misc queries) | |||
Applying Offset to Range in VBA | Excel Worksheet Functions | |||
Applying vlookup to a range | Excel Programming | |||
applying operation to column | Excel Discussion (Misc queries) | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) |