Forum Discussion
Solved
Error when trying to multiply two decimal numbers????
Hi, F13 = B13*C13 gives me an error"#VALUE!" when B13 = 1.79 and C13 = 89.46 but calculates the correct answer when B13 = 2 and C13 = 89 (or any other integers) Why is this happening? Is this a set...
Aravind_D_Varma I suspect that your local settings accept a comma as the decimal separator, i.e. not a point. Try 1,79 and 89,46 in stead.
Aravind_D_Varma I suspect that your local settings accept a comma as the decimal separator, i.e. not a point. Try 1,79 and 89,46 in stead.
Riny_van_Eekelen thank you so much, this actually worked