View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LHorse
 
Posts: n/a
Default the answer to appear in more than one cell

Hi

I copied the formula, made the change to cell reference and it says
not a valid works function, any suggestions?
B3: =INT((B$1-SUM(B$2:B2))/(8-ROW()))

Thanks Laura