Take a look at the LINEST function in XL Help.

In article ,
jk wrote:

Hi,I have two columns filled with numbers,say X and Y.I want to establish a
equation between them.The equation is X=a+bY.The eqution contains two
unknowns.Can you tell me how to find a & b.