applying math operation across range of cells
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.
|