View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amatur wkr amatur wkr is offline
external usenet poster
 
Posts: 1
Default Formula needed for repetative spreadsheet

I would like to generate a list 0.1 to 30.0 (in 1/10th increments) but each
to be multiplied by a specific dollar figure. How do I multiply each cell by
the same number but don't have to enter the formula on each line?