 SOLVED

# Seemingly correct formula...incorrect?

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.

3 Replies
best response confirmed by Serena320 (New Contributor)
Solution

# Re: Seemingly correct formula...incorrect?

@Serena320

Make 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)

# Re: Seemingly correct formula...incorrect?

Thank you very much.
Replacing comma by semicolon worked well.

This brings me to another question..
I started learning how to use Excel very recently with an online training. In the video showed, everyone seems to be fine using comma in the same formula as mine. How come I have to use semicolon when they don't?

# Re: Seemingly correct formula...incorrect?

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.