Cells not correctly calculating on certain computers

[wpryan]

Hi All, I have a bit of a head scratcher. I distributed an Excel file for use in the field, with the worksheets locked to protect the formulas. This file is being used by probably dozens of people without problem - except for two persons. One has the German OS on his computer, the other the Italian OS. Both computers run Windows 7 with Office 2010. A repeating formula in range E31:E40 looks like this:

=IF(ISBLANK(D34),"",IF(OR(D34<<c34-b34,d34>C34-B34,D34><c34-b34,d34>C34+B34</c34-b34,d34>),"Fail","Pass"))<c33-b33,d33>

With the computers showing the problem, the get a #Value error. What is strange, is that when one of the files was returned to me, I saw the error. I unlocked the worksheet to check the formula, and when the sheet unlocked, the cells calculated correctly. After that, I could not repeat the problem. I offered to go online with teamviewer, to check their Excel installations, but to be honest, I don't know what to check - other than the default regional settings for decimal places in Windows (e.g. comma or period).

...any suggestions?</c33-b33,d33></c34-b34,d34>

 

[mole999]

ISBLANK in German is ISTLEER and in Italian VAL.VUOTO

 

[Rick Rothstein]

ISBLANK in German is ISTLEER and in Italian VAL.VUOTO

Given that, perhaps the OP should replace this...

ISBLANK(D34)

with this...

D34=""

 

[wpryan]

Hello, and thanks for your reply. There are other fields in the form that have the ISBLANK in the formula, and are working fine...

 

[wpryan]

I'll give it a try, thanks...

 

[MARK858]

What is in the cells? are they dates?
You state that they are using Italian and Germans OS but what is the OS where you are based (this is the main reason for having the location option on the users profile - which most decide not to fill in)?

 

[wpryan]

Hi Mark, thanks for your reply. The cells are numbers formatted to 3 decimal places. The form is based on English version of Excel and Windows. I'll update my profile, thanks for the gentle reminder