Decimal point or a comma?

When you enter decimal numbers, depending on the Region settings, you will use a decimal point or a comma. In most cases, this is done once, and we don’t deal with this topic anymore. However, it may happen in practice that you import data, most often from a CSS file, where different characters are used to separate decimals and groups than those you use by your local settings. In this case, use the NUMBERVALUE function…

Lists as function arguments

Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…