01-10-2021 09:53 AM
Just in case, after you shift on Finnish formulas which are already in workbooks will be automatically transformed to Finnish notation. Sometimes you need translate formula found on site or some blog into your locale. For example,
Formula for English locale: =INDEX(A1:A10,MATCH(X1,B1:B10,0), IF(X2<Y2,1,2) ) same formula for Finnish locale: =INDEKSI(A1:A10;VASTINE(X1;B1:B10;0); JOS(X2<Y2;1;2) )
For such transformation I'd recommend Translator • Excel-Translator (excel-translator.de) . That's not an advert, just really useful resource.