Ask Your Question

Revision history [back]

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I. I.

GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax). So, it used to be that coding was universal across all nations, but now we are going to screw that up as well? Ah jeez.

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

Updated later:
GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax). So, it used to be that coding was universal across all nations, but now we are going to screw that up as well? Ah jeez.

Changing F2 to =IF(EXACT(E2,"DEBIT"),D2,"") it gives the result "12.8" (I also changed D2 to "12.8" since that is the EN format, but "12,8" simply gives a text result of '12,8' rather than a numeric return of '12.8'). I did originally use semi-colons, same as the OP, but Calc changed them all to commas, twice - I do not know whether that change would make any difference to the OP FR result.

I assume that this is a bug in the FR coding. I cannot assist further, as I'm not prepared to change my locale (I would likely need to reinstall with a new locale to experiment further).

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

Updated later:
GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax). So, it used to be that coding was universal across all nations, but now we are going to screw that up as well? Ah jeez.

Changing F2 to =IF(EXACT(E2,"DEBIT"),D2,"") it gives the result "12.8" (I also changed D2 to "12.8" since that is the EN format, but "12,8" simply gives a text result of '12,8' rather than a numeric return of '12.8'). I did originally use semi-colons, same as the OP, but Calc changed them all to commas, twice - I do not know whether that change would make any difference to the OP FR result.

I assume that this is a bug in the FR coding. I cannot assist further, as I'm not prepared to change my locale (I would likely need to reinstall with a new locale to experiment further).

If this helps then please tick the answer (✔).

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

Updated later:
GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax). So, it used to be that coding was universal across all nations, but now we are going to screw that up as well? Ah jeez.

Changing F2 to =IF(EXACT(E2,"DEBIT"),D2,"") it gives the result "12.8" (I also changed D2 to (D2 as "12.8" since that is the numeric, EN format, but locale) or "12,8" simply gives a text result of (D2 as '12,8' rather than a numeric return of '12.8'). I did originally use semi-colons, same as the OP, but text'). Note that Calc changed them all to commas, the semi-colons (;) to commas (,) twice - (once when first pasting the function in, and second after editing each comma back to a semi-colon). I do not know whether that the semi-colon change would make any difference to the OP FR result.

I assume that this is a bug in the FR coding. I cannot assist further, as I'm not prepared to change my locale (I would likely need to reinstall with a new locale to experiment further).

If this helps then please tick the answer (✔).

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

Updated later:
GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax). So, it used to be that coding was universal across all nations, but now we are going to screw that up as well? Ah jeez.).

Changing F2 to =IF(EXACT(E2,"DEBIT"),D2,"") it gives the result "12.8" (D2 as "12.8" numeric, EN locale) or "12,8" (D2 as '12,8' text'). Note that Calc changed the semi-colons (;) to commas (,) twice (once when first pasting the function in, and second after editing each comma back to a semi-colon). I do not know whether the semi-colon change would make any difference to the OP FR result.

I assume that this is a bug in the FR coding. I cannot assist further, as I'm not prepared to change my locale (I would likely need to reinstall with a new locale to experiment further).

If this helps then please tick the answer (✔).