Discussion Re: Seemingly correct formula...incorrect? in Excel
https://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465553#M103955
Thank you very much.<BR />Replacing comma by semicolon worked well.<BR /><BR />This brings me to another question..<BR />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?Sun, 20 Jun 2021 21:33:27 GMTSerena3202021-06-20T21:33:27ZSeemingly correct formula...incorrect?
https://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465538#M103952
<P>Hello,</P><P>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.</P><P>Could you please help me?</P>Sun, 20 Jun 2021 20:57:10 GMThttps://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465538#M103952Serena3202021-06-20T20:57:10ZRe: Seemingly correct formula...incorrect?
https://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465544#M103954
<P><LI-USER uid="1083679"></LI-USER></P>
<P>Make sure that you use the correct separator between arguments of a function.</P>
<P>If you use point as decimal separator, use comma between arguments, for example</P>
<P> </P>
<P>=VLOOKUP(A2,$F$2:$G$100,2,FALSE)</P>
<P> </P>
<P>If you use comma as decimal separator, you should (probably) use semicolon between arguments, for example:</P>
<P> </P>
<P>=VLOOKUP(A2;$F$2:$G$100;2;FALSE)</P>Sun, 20 Jun 2021 21:01:14 GMThttps://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465544#M103954Hans Vogelaar2021-06-20T21:01:14ZRe: Seemingly correct formula...incorrect?
https://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465553#M103955
Thank you very much.<BR />Replacing comma by semicolon worked well.<BR /><BR />This brings me to another question..<BR />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?Sun, 20 Jun 2021 21:33:27 GMThttps://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465553#M103955Serena3202021-06-20T21:33:27ZRe: Seemingly correct formula...incorrect?
https://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465563#M103956
<P><LI-USER uid="1083679"></LI-USER> </P>
<P> </P>
<P>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.</P>
<P>On such a system, you need to use a comma between function arguments.</P>
<P> </P>
<P>But in many other countries, a comma is used as decimal separator, so that two-and-a-half is written as 2,5</P>
<P>In that case, you need to use a semicolon between function arguments.</P>Sun, 20 Jun 2021 22:15:11 GMThttps://techcommunity.microsoft.com/t5/excel/seemingly-correct-formula-incorrect/m-p/2465563#M103956Hans Vogelaar2021-06-20T22:15:11Z