Hello,

For a project I'm trying to calculate an intercept of some stocks. However, there were some missing values so I couldn't really use the basic "intercept" formula of Excel. After doing some research on these forums I found a way to adapt the formula to make it work with the not available values.

In its current state it is the following: INTERCEPT(IF(ISNA(C4:C204]);"";C4:C204);IF(ISNA(marketreturn!C4:C204);"";marketreturn!C4:C204))

with C4:C204 the range I was interested in for the individual stocks and the market index

However, because the results of my regression weren't what I expected, I tried to change the range from (C4:C204) to (C4:C204 ;C266:C315) (looking to past aswell as future returns of the stock instead of only past returns)

This gave the following formula:
INTERCEPT(IF(ISNA(C4:C204;C266:C315);"";C4:C204;C266:C315);IF(ISNA(marketreturn!C4:C204;C266:C315);"";marketreturn!C4:C204;C266:C315))

This ofcourse did not work. Excel tells me I have inputted too many data. ( I suppose it means the ";C266:C315") Sadly I'm not very skilled with these formula, so that's why I'm here asking you guys for help.

Thanks in advance!
Nils