View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default "Slope" and "intercept" function help

No. The two arguments for each function must be contiguous blocks of cells, though the two blocks
don't need to be near each other.

--
HTH,
Bernie
MS Excel MVP


"BGKeen629" wrote in message
...
Can I use the functions of "slope" and "intercept" to select non-contiguous
sets of values?