Named functions question

[Alexander_Golinsky]

Hi! it's known that using mega functions (functions which are a combination of several separate function) is favorable in terms of time it takes to calculate. My question is, and i didn't find the answer on web, whether naming functions affects calculations time. To give you a sense of this question importance, take a look:

This function is used on one sheet 365*22 times:

=SUM(IF(OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22)>=$A60,OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0)+3,1,,22),0)*(IF(EXP(-(IF(OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22)>=$A60,($AO60+($AP60+$AQ60)*($AR60/(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365))*(1-EXP(-(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)/$AR60))-$AQ60*EXP(-(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)/$AR60)+$AS60*EXP(-((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)^2)/2)+$AT60*EXP(-(((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)-1)^2)/2)+$AU60*EXP(-(((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)-2)^2)/2))))*(IF(OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22)>=$A60,(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365),0)))=1,0,EXP(-(IF(OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22)>=$A60,($AO60+($AP60+$AQ60)*($AR60/(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365))*(1-EXP(-(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)/$AR60))-$AQ60*EXP(-(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)/$AR60)+$AS60*EXP(-((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)^2)/2)+$AT60*EXP(-(((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)-1)^2)/2)+$AU60*EXP(-(((((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365)-2)^2)/2))))*(IF(OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22)>=$A60,(((OFFSET(DATA!$A$1,MATCH(INDEX(Base_tickers,MATCH($A60,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0),1,,22))-$A60)/365),0))))))

and it takes 3 min. just to load the file.


And now the same function, but when it possible written using named functions:

=SUM((IF(Find_future_dates,OFFSET(DATA!$A$1,Ticker_row_DATA+3,1,,142),0))*(IF(EXP(-(IF(Find_future_dates,Model/10000))*(IF(Find_future_dates,Maturity,0)))=1,0,(EXP(-(IF(Find_future_dates,Model/10000))*(IF(Find_future_dates,Maturity,0)))))))

For some reason, i cant just compare. so i'm asking you - maybe you know. Thanks in advance.