Hello,

I have a formula in google sheet but when you download as excel the formula is changed as below.

Google sheet -
=((QUERY(transpose(I413:T413),"Select Col1 where Col1 is not null limit 1",0))/(ArrayFormula(iferror(lookup(1,I413:T413/I413:T413,I413:T413)))))^(1/(counta(I413:T413)-1))-1


Convereted to below in excel

=IFERROR(@__xludf.DUMMYFUNCTION("((QUERY(transpose (I413:T413),""Select Col1 where Col1 is not null limit 1"",0))/(ArrayFormula(iferror(lookup(1,I413:T413/I413:T413,I413:T413)))))^(1/(counta(I413:T413)-1))-1"),0.000510855849876756)


Need your help in fixing this issue.