I am downloading a Google spreadsheet as Excel (XLSX). Everything works fine EXCEPT any cell with either MAXIFS or MINIFS inside the formula place an @ sign after the = in the beginning of the cell, which causes the cell to value as a #NAME. Below is an example:
=@IF(SUM(G72:G551)>0,MAXIFS(F72:F551,G72:G551,">0"),'BOND INPUT'!G44)
Does anyone know how to eliminate the @? The EXCEL file is fed into a system so EXCEL .xlsx file is never actually opened in EXCEL.
I don't think that #NAME? is caused by @ as it's valid in Excel 2019 and 365. MAXIFS and MINFS were introduced in 2019.
Firts you have to use a recent Excel version. If the error arises in the system where teh spreadsheet is bein loaded, then it's very likely that is using and old Excel file parser.
Anyway, the @ can't be removed from the Google Sheets download as built-in function. You could remove it by editing the downloaded file.
Resources