|
|
#1
12-14-2021, 05:04 PM
|
|||
|
|||
Google sheet formula convert to excel
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| a formula for this excel sheet: | emvella | Excel | 1 | 09-14-2019 05:57 PM |
| Update Excel worksheet from Google sheet | tasneemj | Excel | 0 | 02-11-2018 12:17 PM |
| Convert From Google to Microsoft for everything | MarkNicholson100 | Office | 0 | 02-23-2017 01:41 AM |
 Error in exporting Google Sheet to Excel
|
cmcmeekin | Excel | 2 | 08-03-2016 11:32 AM |
| Excel formula from looking the base date and convert into desire result | PRADEEPB270 | Excel | 1 | 02-17-2013 03:11 AM |
Windows 10 
Office 2019
Threaded Mode