Registered User Joined: 4/30/2015 Posts: 197
|
(MINL78 - ( ( ( MAXH78 - MINL78 ) * 0.382 ) - (MAXH78 - MINL78) ) )
THIS FORMULA PRODUCES CORRECT IN USA, BUT FOR A USER WITH WITH WINDOWS THAT HAS REGIONAL SETTINGS CONFIGUTED WITH , COMMA AS DECIMAL SEPARATOR TRANSLATE THE # IN THE FORMULA 0.382 BECOME 382
When . changed to a comma, it doe not fix this problem
|
Registered User Joined: 4/30/2015 Posts: 197
|
We got it thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am happy to read you were able to figure it out on your own.
I normally just try to rewrite the formula so it does use a decimal marker at all.
(618 * MAXH78 + 382 * MINL78) / 1000
-Bruce Personal Criteria Formulas TC2000 Support Articles
|