Tag Info

New answers tagged

1

If you want to make sure that MS Excel 2010 files are properly converted and still work in Google Spreadsheets, then don't use the following formula's: AMORDEGRC AMORLINC AREAS ASC AVERAGEIF AVERAGEIFS BAHTTEXT BESSELI BESSELJ BESSELK BESSELY BETADIST BETAINV CALL CELL CHIDIST CHIINV CHITEST CLEAN COMPLEX CONVERT COUNTIFS CUBEKPIMEMBER CUBEMEMBER ...


0

I bashed up a comparison sheet for the formula's between MS Excel 2010 and Google Spreadsheet. Comparison was based on the names only. See snapshot of the current situation: If you want to make sure that Google Spreadsheet files are properly converted and still work in MS Excel 2010, then don't use the following formula's: ADD ARRAYFORMULA CONCAT ...



Top 50 recent answers are included