white_flag
12-09-2010, 01:56 PM
Hello,
I have an line really long, something like this (result from VBA):
ex:
=(PI()*(2*I$11+$B15)/1000*(0.276)+0+PI()*(2*I$11+$B15)/1000*I$11/1000*0+19.74*(1-50/100)*(1+20/100)+7.5/60*36.5+(PI()*(2*I$11+$B15)/1000+0.05)*INDEX(cladding,1,1)*(1+5/100)*(1+10/100)+INDEX(m_cla,MATCH($B15,Data!$C$50:$C$70,1),IF(ISNA(MATCH(I$11,Data!$C$ 50:I$50)),1,MIN(IF(ISNA(MATCH(I$11,Data!$C$50:I$50,0)),MATCH(I$11,Data!$C$5 0:I$50)+1,MATCH(I$11,Data!$C$50:I$50,0)))))/60*36.5*1+INDEX(prefab,IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13)),1,MI N(IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)),MATCH((2*I$11+$B15),Dat a!$AC$5:$AC$13)+1,MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)))),2)*1)*1
how can be done, that in excel, to have only the values?
Application.Evaluate - I guess it is not going here.
thank you
I have an line really long, something like this (result from VBA):
ex:
=(PI()*(2*I$11+$B15)/1000*(0.276)+0+PI()*(2*I$11+$B15)/1000*I$11/1000*0+19.74*(1-50/100)*(1+20/100)+7.5/60*36.5+(PI()*(2*I$11+$B15)/1000+0.05)*INDEX(cladding,1,1)*(1+5/100)*(1+10/100)+INDEX(m_cla,MATCH($B15,Data!$C$50:$C$70,1),IF(ISNA(MATCH(I$11,Data!$C$ 50:I$50)),1,MIN(IF(ISNA(MATCH(I$11,Data!$C$50:I$50,0)),MATCH(I$11,Data!$C$5 0:I$50)+1,MATCH(I$11,Data!$C$50:I$50,0)))))/60*36.5*1+INDEX(prefab,IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13)),1,MI N(IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)),MATCH((2*I$11+$B15),Dat a!$AC$5:$AC$13)+1,MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)))),2)*1)*1
how can be done, that in excel, to have only the values?
Application.Evaluate - I guess it is not going here.
thank you