View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Oligo Oligo is offline
external usenet poster
 
Posts: 27
Default linear interpolation macro help

say i have a table data

A B C D
1 9 15 5
2 12 19 18
3 15 22 30

when A = 1.5, it will interpolate the table array to get the corresponding B
C D values.

how do i write the macro??