I have a problem in acquiring decimal number from users. They write a number in a cell and then I verify if that number is inside a specific range. The decimal separator of both the system and Excel where I work is the comma. Example (I will use the comma as a decimal separator to be consistent with my problem): the user insert 3,7 (Dim1) and the upper limit of my range is given by summing the default value (3,4, called Dim1_nominal) and a tolerance, which is 0,3. The values of Dim1_nominal and tolerance are taken from a table with a list of nominal values and tolerances. I wrote a boolean equation stating: if Dim1<= Dim1_nominal + Tolerance Then.
The problem is that the boolean equation is False, while I would expect True.