Jun 20 2021 01:57 PM
Hello,
Each time I type a formula (to create new rules to highlight cells for example), an error message appears and says the formula is incorrect. Plus it doesn't say where. Yet the formula is very basic and seems perfectly correct.
Could you please help me?
Jun 20 2021 02:01 PM
SolutionMake sure that you use the correct separator between arguments of a function.
If you use point as decimal separator, use comma between arguments, for example
=VLOOKUP(A2,$F$2:$G$100,2,FALSE)
If you use comma as decimal separator, you should (probably) use semicolon between arguments, for example:
=VLOOKUP(A2;$F$2:$G$100;2;FALSE)
Jun 20 2021 02:33 PM
Jun 20 2021 03:15 PM
It depends on your system settings. Most tutorial websites and training videos assume that you use a point as decimal separator: for example two-and-a-half is written as 2.5 as is usual in the USA and UK.
On such a system, you need to use a comma between function arguments.
But in many other countries, a comma is used as decimal separator, so that two-and-a-half is written as 2,5
In that case, you need to use a semicolon between function arguments.
Jun 20 2021 02:01 PM
SolutionMake sure that you use the correct separator between arguments of a function.
If you use point as decimal separator, use comma between arguments, for example
=VLOOKUP(A2,$F$2:$G$100,2,FALSE)
If you use comma as decimal separator, you should (probably) use semicolon between arguments, for example:
=VLOOKUP(A2;$F$2:$G$100;2;FALSE)