How can i set a formula into a ceil wich works on every lang ? (SUM, ROUND..) #359

New Issue

2016-01-28T16:18:50Z

wawanopoulos commented

2016-01-28 16:18:50 +00:00

(Migrated from github.com)

I search a way to add into a ceil a formula like : ROUND((A1*B1);2)
If i put this line it will works fine if Excell is in English. But how can i do to modify this formula to be able to make this ROUND function for all Excell languages ?

I search a way to add into a ceil a formula like : ROUND((A1*B1);2) If i put this line it will works fine if Excell is in English. But how can i do to modify this formula to be able to make this ROUND function for all Excell languages ?

SheetJSDev commented

2017-04-01 04:21:51 +00:00

(Migrated from github.com)

You have to write the formula in the "English" style, with English names (e.g. ROUND) and commas to separate arguments. The correct formula in this case is:

ROUND((A1*B1), 2)

And this should do the right thing in other languages.

You have to write the formula in the "English" style, with English names (e.g. ROUND) and commas to separate arguments. The correct formula in this case is: ``` ROUND((A1*B1), 2) ``` And this should do the right thing in other languages.

Sign in to join this conversation.