View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Conditional Function Application

Hi Russ,
you could use 20 (or so) columns, 1 for each function with an IF so
that x values outside its working domain result in a blank cell ("")
while x values within its working domain result in the interpolation
function value. Then in the column after the 20 or so function columns
you could use the MAX formula to assemble the calculated values into
that column.

Ken Johnson