View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yb yb is offline
external usenet poster
 
Posts: 1
Default 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.