Formulas and regional settings

[wpryan]

Hello, I have a spreadsheet that I developed on a Windows 7 computer, with an English OS and Swiss German keyboard. Regional settings are for Swiss German keyboard and number format. This file is shared amongst a large group of people around the world.
In it, there is a range with a simple formula:

<c31-b31;d31>=IF(ISBLANK(D31);"";IF(OR(D31 < C31-B31;D31 > C31+B31);"Fail";"Pass"))

If the regional settings of the computers are set to anything other than Swiss German, the users get a #Value error. I can't for the life of me figure out why this is the case.

...any help is appreciated.</c31-b31;d31>

 

[Aladin Akyurek]

Care to show what you exactly have in B31, C31, and D31? If these cells contain true numbers (true dates or true time values, etc.), there should arise no problems.

 

[wpryan]

Thanks for your response. All cells are formatted as numbers, to three decimal points.

 

[Aladin Akyurek]

Thanks for your response. All cells are formatted as numbers, to three decimal points.

what are the results of the following checks?

=isnumber(b31)
=isnumber(c31)
=isnumber(d31)

 

[Fennek]

Hello,

just guessing:

in German and obviously Swiss German formulas in the worksheet the separator is a ";", in english versions it is a ",". But to my understanding xl should adopt automatically.

Grützi

 

[wpryan]

I think you're on to something... Cell B31 has a formula as well, which is dependent on the entry of another cell in the workbook. The formula is:

=IF(OR('General Data'!$B$10="Crystal or Classic";'General Data'!$B$10="Z2");"0.100";"0.015")

However, cell B31 is formatted as a number, with 3 decimal places. It looks like the formula is overriding the formatting of the cell. How can I force a numerical value here?

 

[MARK858]

Remove the quotes around the numbers in the formula.

 

[wpryan]

Duh! Thanks for that, I was having a brain fart for a minute...